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.

How to stop updating in transform map field mapping on certain conditions

Raviteja Kunal1
Tera Expert

I have a use case where data will be coming from SAP in three rows and if any of the rows having a value in field called block we need to set the value blocked = true in target table field. But I am facing an issue like, if one row updated value to blocked = true and later another row making the value to false again. How to fix this issue in transform map.

 

Thank you.

8 REPLIES 8

Anantha Gowrara
Kilo Sage

@Raviteja Kunal1 Can you just update line 6 as below and remove line 7, also check if there is any other mapping available for blocked field.

line 6 - return true;

 

Raviteja Kunal1
Tera Expert

no there is no other mapping for that field

Anantha Gowrara
Kilo Sage

@Raviteja Kunal1 ok, can you confirm if blocked is setting to true at initial stage or its never getting updated?

Raviteja Kunal1
Tera Expert

@Anantha Gowrara it is setting to true at the initial stage later it is again setting to false when above conditions are not met.