Getting an error while loading data in a reference field using transform maps

[Shusovit]

I am getting a error: 

Reference field value for u_location ignored: ZM02

even though my record is being updated with the correct value.

Here "ZM02" is the unique value of location table. The value is present in the table also.

[matthew_magee1]

Shusovit-

Try using the sys_id of 'ZM02' instead of the unique value

[Shusovit]

But in excel sheet I have to use the this unique value only, then how to check with the sys_id ?

[matthew_magee1]

In your transform map, you could run a script that will take the unique value, 'ZM02' and do a glide lookup against the table where the unique value resides, get the sys_id, then populate the reference field using current.setValue('<sys_id>');

Hope this helps-

[scott barnard1]

hi shusovit

in your transform map you get options for reference fields

so you get to set behaviour

ZM02 - exists carry on and update

ZM02 - doesn't exist create

ZM02 - doesn't exist ignore

Have a look at your map and see what is set

Regards