on 12-29-2010 4:35 PM
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
if field2!="INVC" then abs(field1) else abs(field1).concat("-")
-
Srikanth Srinivasan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.