We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Skip import set record when empty field available in file

Mohan22
Tera Expert

Hi Team,

 

I want to skip the records while importing from data source if name field is empty and also need to skip records if name field have duplicate values?

 

Thanks,

Gan

2 REPLIES 2

Murthy Ch
Giga Sage

Hi @Mohan22 
For your first point you can below logic in onBefore transform script:

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

    // Add your code here
    if (source.u_name == "") //here replace with your name field
        ignore = true;

})(source, map, log, target);

For avoid duplicate you can check the Coalesce field.

MurthyCh_0-1666714557940.png

Hope it helps

 

 

 

Thanks,
Murthy

Thanks for quick response.

we are not looking while transform. we are looking at importing the data into data source