Insert for Transform map

[Priya123]

hi all

i have a transform map where i have a coalesce field.

I want to only update records if coalesce is true 

No insert if  no match

provided the below script on the Run Script on the transform but its still inserting. 

(function transformRow(source, target, map, log, isUpdate) {

   if (action == 'insert' ){

        ignore = true;

        }

})(source, target, map, log, action==="update");

[Priya123]

this worked partially.. so basically it created new records. but empty ones. Like blank records. am not sure if its cos i gave Copy empty field on the transform map but thats needed for other columns that am updating. 

[Priya123]

i did onbefore only and it created blank records 

[Priya123]

Create new record on empty coalesce fields

 this as well is unchecked. not sure why is it creating blank records.

[Shubham Singh]

Hi @Priya123 

Check if the Coalesce is checked for any other fields in field mapping on the transform map. If it is checked for multiple fields, it will consider the record as a match only if all the fields' value matches.

Thanks!

Please mark it as correct and helpful if it works ✔️👍

[Priya123]

no only one field is a Coalesce for this map