Records getting duplicating while uploading data from Excel table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2022 03:36 AM
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2022 04:50 AM
What's the coalesce on your transform map?
If my answer helped you in any way, please then mark it as helpful.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-27-2022 05:08 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 07:37 PM
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