. 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 🙂
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
Thanks for the update. I checked it again and basically what I was doing was running a query on something that already had that field in it so it just created a duplicate of the field...DOH! Thanks for the answer - 🙂