Would like to coalesce Sys ID field and yet it ends up with a new record
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2024 11:34 PM
Hello folks,
I was not able to figure out the issue described in the title. What follows is the actions I took:
- I tried to update an existing record in Discovery Schedule table by using Import Sets. I first exported an Excel file of that table, then edited the values in the records stored there, and imported them with the aim of updating the values of existing records.
- To do so, I had displayed Sys ID field on the Discovery Schedule table, which I used to coalesce imported data with existing records, and made sure that the record I meant to update had the same Sys ID with the existing one.
- When setting up a Transform Map, I enabled coalesce for Sys ID field and executed the import.
Contrary to my anticipation that it would work, it always ended up creating a new record with a Sys ID that seemed newly allocated to an imported data.
Has any of you got any suggestions as to how I could update existing records by employing Import Sets?
Any help would be very much appreciated.
Kota
0 REPLIES 0