Records getting duplicating while uploading data from Excel table

[Ankit Pal]

Hi all

I have a quick question. I am trying to upload data from an excel sheet into Service Now users table by using import sets and transform map. In excel sheet I have few columns, two columns containing names. These fields are reference fields in my Users form. The problem is when upload the data, the records I need gets created, but also some extra records of those names are getting created. Those records only contains names and nothing else. I don't want those extra records in my table. Could anyone please tell me the solution to this problem?                

Thanks

Ankit  

[Mark Manders]

What's the coalesce on your transform map?

If my answer helped you in any way, please then mark it as helpful.

Mark

[Ankit Pal]

I have tried it with Coalesce, but it did not work out. Previously I had tried with one by one Coalesce to true for User ID, then the names too. but it did not work out. 

[Mariano Lemus]

Use coalesce in the field that has the unique value of your imported records, which needs to be aligned to the sys_user table.

In some places I have seen coalesce for user_name field, because it is the unique identifier.

Cheers,

M