

May 2, 2014

. I have built a PQ file that was working perfectly but when I went to refresh it I got the following: "Expression.Error: The field 'Deferred_Days.2' already exists in the record and so on for about 15 fields...grrrrr.ย
I've googled it but don't understand the answer as it referred to "bucketed fields". The field name e.g. Deferred Days, now exists in the data set which is the PQ output - I had created it as a custom column with a formula so I reckon what is happening is that PQ thinks it shouldn't be there..and creates a new one...What do I need to do to fix it? Thanks as always ๐


July 16, 2010

Hi Anne,
I'm not sure I understand the data structure, but I wonder if there is a circular reference in the query e.g. the query gets data from all tables in the file. You then load the table to the file and it tries to get itself?
I'd need to understand more about what the query is doing, where it's getting the data and where it's loading the data to.
Mynda
1 Guest(s)
