Transform Map needed to update Reference field

[Saib1]

Hi ,

I need transform map to update the reference field.

I have the excel sheet it contains the data .

I need this to be updated on the Maintain Items reference field 

[Periyasamy P]

In your transform map, field mapping enter your reference table column name where this OracleDB/LinuxDB present. So, it will match excel value with your reference table and update the data

[Saib1]

that value is not present in reference table . Eventhough it will get updated?

[Periyasamy P · Accepted solution]

Then set choice action value as create, so that it create new record and update.