Import set not updating old records

[Anu Singh1]

Hi Team,

I am doing import to the custom table and I am trying to coalesce multiple fields during import. I want to update every record where this field matches. Import seems to update the first matching record but not the old records if the same coalesce value matches. In my source table data is coming through schedule job which get data from REST end point...so the source data keep updating every time this schedule run.

Attaching screenshot for your reference..

I have put coalesce on Application, DB Name, Environment and role. Kindly help me to fix this issue and share your thoughts.

[Ankur Bawiskar · Accepted solution]

@Anu Singh 

Divide the older data in chunks of 10k each

Regards
Ankur

[Anu Singh1]

thanks Ankur