Transform map : how to check all records before insertion

[naxis alx]

During transform map, I want to check all data before inserting in target table.

I want to abort if certain conditions do not match and send error message.

I want to abort all records if even one condition is not met.

[Manmohan K]

Hi @naxis alx 

You can utilize on Before Transform scripts to validate data before inserting into target table

Follow given community thread for more details of your requirement - https://www.servicenow.com/community/developer-forum/onbefore-transform-script-to-ignore-insert-if-n...

[Aman Kumar S]

Hi @naxis alx ,
You can use onstart transform script for the same, and set ignore = true;