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.

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