Forum

How to resolve "the...
 
Notifications
Clear all

How to resolve "the field already exists in the record" issue?

3 Posts
2 Users
0 Reactions
2,002 Views
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

. 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 🙂

 
Posted : 01/11/2018 7:45 am
(@mynda)
Posts: 4762
Member Admin
 

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

 
Posted : 02/11/2018 2:17 am
(@agwalsh)
Posts: 100
Estimable Member
Topic starter
 

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 - 🙂 

 
Posted : 20/11/2018 9:02 am
Share: