Is there a way to ignore a row by using source script or this need to be done using tranform script?

Daniel Rodrigue
Mega Expert

I need to create a script on the transform map to ignore certain rows with specific values.

The idea is to solve this by using a field source script, but I am just beginning in ServiceNow and I don't if this is possible or I need to use transform script instead.

I already checked other forum topics but I only found this solution by using ignore=true on the transform script when the condition is met but I want to make sure if this can be done using the field source script.

Thanks!

1 ACCEPTED SOLUTION

Anil Lande
Kilo Patron

Hi Daniel,

You cannot use ignore=true in Field Source script:

You can use it only in onStart scripts, this variable aborts the entire transformation process. In onBefore scripts, this variable only skips the current row being transformed.

 

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

View solution in original post

5 REPLIES 5

AnirudhKumar
Mega Sage
Mega Sage

This cannot be done with field map source script.

Hello!

Thanks for your answer

Anil Lande
Kilo Patron

Hi Daniel,

You cannot use ignore=true in Field Source script:

You can use it only in onStart scripts, this variable aborts the entire transformation process. In onBefore scripts, this variable only skips the current row being transformed.

 

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Thanks for your answer!

Best regards!