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?