cancel
Showing results for 
Search instead for 
Did you mean: 

how to do mapping for my below condition plzz tell me udf or graphical map

former_member191435
Contributor
0 Kudos

Hi folks....

Input has 2 fields field1 and field2 and i need it to output side of field target

If field2 = "INVC" then Add minus sign "-" to the right hand side of the field1 else remove the minus sign from the left hand side...

Plea

Please help me on this issue...

Thanks,

Enivass

Accepted Solutions (1)

Accepted Solutions (1)

srikanth_srinivasan3
Active Participant
0 Kudos

if field2!="INVC" then abs(field1) else abs(field1).concat("-")

-

Srikanth Srinivasan

former_member191435
Contributor
0 Kudos

Thanks Srikanth

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Try this(if i understood u correctly):

field2----


-


equalS--IfThenElse--Target

constant(INVC)------

Mapping of "then":

filed1----


-


Concat-----then

Constant(-)----

Mapping of "else":

field1----else

Thanks

Amit