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

[Alon Grod]

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;

}

[Namrata Ghorpad]

Hi @Alon Grod ,

Update script like below.

if (source.u_computer_name == '') {
     ignore=true;
}
else {
       return source.u_computer_name;

}

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

Regards,

Namrata

[Namrata Ghorpad]

Hi @Alon Grod ,

Please refer the below link.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1124334#:~:text=Add%20and%2Fo...

Regards,

Namrata

[Rahul Kumar Ko1]

Hi @Alon Grod ,

Please use the On-before transform script to avoid the insertion like below

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

    if(gs.nil(source.todo_url))

        ignore = true;

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

Kindly mark this answer as helpful if this works for you

Thanks,

Rahul.

[Alon Grod]

@Rahul Kumar Ko1 @Namrata Ghorpad Im using source script in order to populate specific field and during this process i want to check if its empty then script entire row. It should not be something with AbortAction?