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

Daniel Rodrigue · ‎05-01-2021

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!

Anil Lande · ‎05-02-2021

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

Daniel Rodrigue · ‎05-03-2021

Hello Anil!

Thanks for your answer.

Best Regards!