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");

[harshav]

Write an onBefore transform script

var gr = new GlideRecord('your_table_name'); // this one is your target table
gr.addQuery('number', 'xxxxx'); // here your coalese field name
gr.query();
if(!gr.next()){
    ignore = true;
}

[Priya123]

Still inserting. tried this too

[harshav]

Can you please share your code

var gr = new GlideRecord('your_table_name'); // this one is your target table
gr.addQuery('number', source.u_number); // here your coalese field name
gr.query();
if(!gr.next()){
    ignore = true;
}

In line 2 are you bringing your importset field name. Also make sure is there any other script on After or on before with different condition

[Sandeep Rajput]

 @Priya123 You should configure onBefore Transform script as follows.

Source: https://developer.servicenow.com/dev.do#!/learn/courses/utah/app_store_learnv2_importingdata_utah_im...