i am trying to implement the logic in tranformer stage can somone help me on this how i can i use this transformation rule.
Code: Select all
(If {OBLT.OBL_COL_TT} in 0 to 99 then
'0' else
mid(ToText({OBLT.OBL_COL_TT},0,""),1,1))='2'and {OBLT_USER_DATA.USER_CD_2}='A')then 'N'
Code: Select all
if {OBLT.OBL_COL_TT}in [200,250] then 'AH'
else 'AG'