Data source import creating duplicates instead of updating records

[mdjoseph12]

I've set up a data source that is pulling a csv file via an ftp source but whenever I attempt to test load 20 records, it creates inserts as opposed to updating the records that currently exist in the database. Currently I am coalescing on the serial number of the record, is there any other way I can ensure that records are updated as opposed to created? 

[Ankur Bawiskar · Accepted solution]

Hi Joseph,

If you are giving serial number as coalesce then if it finds that value in target table it would update; if not found then it would create.

Did you check those 20 serial numbers are already present in the target table?

Also check any spaces before or after the serial number is causing the import row to insert rather than updating

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[mdjoseph12]

Yes I did check and the serial numbers already exist, and no spaces existed in the serial numbers that I found. Would it help to coalesce on multiple values? 

[Devyani_6]

Hi,

Have a look on below service now thread, this will help you.

https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/import-sets/concep...

Mark Correct/Helpful, if this helps you.

Regards,

Devyani

www.dxsherpa.com

[Devyani_6]

Hi,

If the answer resolve your query, please mark the answer correct, so that it get removed from unanswered category.

Regards,

Devyani