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
