How to ignore an insert from data load via transform map.

[John Levi]

Hello,

Is there any way we could ignore any new insert if my coalese field is not matching the existing record. I want to skip such record i.e. it should not insert into the target table.

Regards,

John

[Shubham Tipnis · Accepted solution]

Hi John,

Please create a OnBefore transform map script and use the below code to ignore any new inserts.

 
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    if (action == 'insert') {
        ignore = true;
    }
})(source, map, log, target);

Please mark correct/helpful if applicable.

Regards,
Shubham