question Records getting duplicating while uploading data from Excel table in München SNUG

Records getting duplicating while uploading data from Excel table

Ankit Pal — Wed, 27 Jul 2022 10:36:30 GMT

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

Re: Records getting duplicating while uploading data from Excel table

Mark Manders — Wed, 27 Jul 2022 11:50:33 GMT

What's the coalesce on your transform map?

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

Mark

Re: Records getting duplicating while uploading data from Excel table

Ankit Pal — Wed, 27 Jul 2022 12:08:49 GMT

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.

Re: Records getting duplicating while uploading data from Excel table

Mariano Lemus — Sat, 30 Jul 2022 02:37:55 GMT

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,