Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Transform map, skip record rather than ignore

sndev1099
Giga Expert

Hi, 

I need my transform map to skip records rather than ignore them if the user ID doesn't exist in the system. 

find_real_file.png

 

find_real_file.png

16 REPLIES 16

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

please refer below link

you are already ignoring

see below difference between ignore and skip

  1. inserted - the record was inserted
  2. updated - the record was updated
  3. ignored - the input was ignored, the record was not updated and no new record was created
  4. skipped - the input data was skipped (similar to ignored) due to missing coalesce values
  5. error - there was an error processing the input.

https://community.servicenow.com/community?id=community_question&sys_id=1a1ac769db5cdbc01dcaf3231f96...

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

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

Thanks Ankur. Is there any way to force it to skip though rather than ignore? 

Hi,

I don't think so; From what I could think is both have same meaning

If my answer solved your issue, please mark my answer as Correct & 👍Helpful based on the Impact.

Regards
Ankur

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

Slava Savitsky
Giga Sage

According to the product documentation, setting ignore = true in an onBefore trandform script should skip the current row. In your case, does it actually get imported?

By the way, is there a reason you have to use an onBefore transform script rather than a field map script with Reject as Choice Action?