How to skip a row in transform map insertion if field is empty

Alon Grod
Tera Expert

Hi,
how can I skip a row insertion in transform map if field specific field is empty.

 

if (source.u_computer_name == '') {
     skip row
}
else {
       return source.u_computer_name;

}

6 REPLIES 6

Hi @Alon Grod ,

Please refer the below link.

https://www.servicenow.com/community/developer-forum/is-there-a-way-to-ignore-a-row-by-using-source-... 

 

If my answer resolves your issue then please mark it as correct and helpful.

Regards,

Namrata

Ankur Bawiskar
Tera Patron
Tera Patron

@Alon Grod 

you can use onBefore transform script.

But please share what script you are using currently?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader