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.

[asifnoor]

Hi,

If there is a change in the import record, only then the records will update. if no change in your source record, then update will not happen.

Mark the comment as a correct answer and helfpul if this helps.

[Anu Singh1]

Thanks for your response..

I understand Coalesce identify unique records but how can I update the old records which was already present in the custom table before the import. I cannot clean-up those records manually as it will cause data loss on existing tickets with these record values. 

[Sai Kumar B]

Hi @Anu Singh,

1.) Take the export of old records from the list view and update them in excel

2.) Import the exported excel with old records updated values 

3.) Once you apply the coalesce in the transform map, then import the file from point 2 and run the map old record values will be updated in table

This is the approach to update the existing records in the table.

Please mark my answer as helpful/correct, if applicable.

Best Regards,

Sai Kumar

[Anu Singh1]

Hi,

It is in large number. Custom table has 28k old records. If I export it in excel form it is not downloading all the records.