We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Stop processing of row when invalid reference field value is found in robust transform map

AchyuthS
Tera Contributor

I am working on Robust Transform map where my requirement is to skip complete row when value of any reference field is not found.

I have created 4 entities as follows,

1) ImportSet - which is import set table

2)Staging - temporary table

3)Windows - target table1

4)Linux - target table2

 

I have attached screenshot for reference.

I am not understanding where to write script but I created RTE entity Operations at staging table (nothing but temp table).

 

Coercion as reject in target field level is not working for reference field of target.rte1.pngrte3.pngrte2.pngrte4.png

1 REPLY 1

Runjay Patel
Giga Sage