Use case that I need help with:
I’m working on a cleanup activity for the Location table. There are multiple location records with the same name, but each one has its own sys_id (as expected).
I have an import file that contains the exact sys_id of the Location record that needs to be updated.
What I want to do:
Use the sys_id from the import file to find the corresponding record in cmn_location
If a match is found, update the existing record with the new values from the import (name, ERP ID, etc.)
I am doing this using a Transform Map
Problem:
No matter what I try, the transform either:
creates a new Location record,
or sets the name field to the sys_id value instead of updating the existing record.
Question:
What am I missing? How do I correctly configure the Transform Map so that it updates the existing record using the sys_id from the import file?
Thank you,
Rajesh
