Duplicate entries in import tables while

[vikas_sakhare]

I have three transform map. Let's say T1, T2 and T3 .The source tables for all are same but target tables are different. Transform maps are completely working find but its get duplicate entries in import tables. I want to avoid that. Can anybody tell me how can we achieve that?

Thanks in advance!

[Karthik Reddy T · Accepted solution]

Hello Vikas,

Please make coalesce as     true   for a field in the transform   map. coalesce will prevent to create duplicate records.

Using the Coalesce Field - ServiceNow Wiki

Coalesce options

[tony_barratt]

Hi Vikas,

Could you explain a bit more about the duplicate entries seen in your import tables?

As already mentioned defining a coalesce field in the transform map can prevent duplicates in the target table.

import set tables can have "duplicates' as the same values can in normal circumstances be pushed into the import set tables.

when you carry out a daily load from LDAP for example the same values may be populated in the import set tables - the SET number will be different however.  

If the reply was informational, please like, mark as helpful or mark as correct!

[vikas_sakhare]

Thanks Anthony, It really helped to me