Using transform map to update record

[Ken61]

I have a requirement to update "Model Type" field on cmdb_hardware_product_model table and not create new record.

I have excel file with the correct Model type, Name and sys_id of the records.

sys_id is needed because we have various record with the same name.

Transform map was created but this is not working as expected. Below is the screenshot and transform script that was created but those record was not updated. What am I doing wrong here.

Please assist on how to update the records without creating new records.

[Brian Lancaster]

Just to clarify are you saying that no inserts are being done as well as no updates? If that is correct then your two fields that your are correlating on do not match what is in the system. Everything looks fine in your setup. You should be able to correlate on just sys_id however as this is unique. 

[Ken61]

Thanks @Brian Lancaster. I was able to make it work, I selected wrong sys_id field from the source table. 

This is working fine now.