Unable to update the field data in location table with transform map

[RajeshS45028713]

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

[Mohammed8]

@RajeshS45028713 

What field you have set as coalesce here?  sys_id right? check sys_id do not have spaces and all

Would be helpful if u shared SS  of your dataset,  and how u r mapping to understand better.

Regards,

Mohammed Zakir

[RajeshS45028713]

Hi @Mohammed8 
yes, i am doing the same...
PFA for your reference

[Mohammed8]

@RajeshS45028713 

Sorry for late reply, somehow i missed your reply.

I have tried on my PDI and it updates location for me. When mapping, do check u r using right sys_id, i can see there are two, in my excel sheet I have used sys_id as column name to avoid this confusion label it as system_id or something else

Regrads,

Mohammed Zakir

[RajeshS45028713]

Hi Zakir,

Thanks for the response sure i am making the sys_id as coalesce.

PFA for the references and looking Forword for the responses