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.