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

shraddhakar
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

Hi @shraddhakar ,

Follow this step by step guide on Robust TM.

https://servicenowwithrunjay.com/robust-import-set-transformers/

You can check this video for live implementation: https://youtu.be/8B-mf3FmDfc?si=ptZPFHGZniJaJMO3