If the record is present , How can we update that records in target table using transform maps

[Munna1]

Hello,

While I am trying to push any data (or create any record ) in source table, it is creating in target table. But it is not updating. I have already set the Coalesce True.

Field Mappings 

Here User field in the target table is Reference field so that's why i am sending the sys_id in the below script.

Any suggestions please...

Thanks..

[Swapna Abburi]

Hi @Munna1 

if you are already getting user ID in source field then update the 'Referenced value field name' in your field mapping to 'user_name'. There is NO script required for Source script. 

If you want to use sys_id then you can keep the Source script and update the referenced value field to 'sys_id'.

[Munna1]

Hi @Swapna Abburi ,

Thanks for your response,

As you mentioned I added the sys_id in Reference value field,  But the record is still not updating when ever I insert the record with the existing user sys_id, in staging table, It's just creating the record.