on 03-18-2019 5:14 PM
What would be the right syntax for If statement with an "if" statement and "And"?
INTRN=*IF(EMPGROUP=*STR(C) and *JOB=*STR(TEMP) THEN *STR(S); *STR())
When I use above syntax, transformation file is finding error with "And".
Why not to read help???
There is no "and" operator supported!
"And" logic can be simulated by:
INTRN=*IF(EMPGROUP+JOB=*STR(CTEMP) THEN *STR(S); *STR())
From help:
"Condition1 and Condition 2 can contain multiple items that are added together (using the plus (+) sign)"
P.S. Even sample is provided in help:
Mapping Function 1:
Product=*IF (product+ID+Entity=*Str(148552) then *str(MHarn); ID(1:1) = *str(C) then *str(XX); *str(YY))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
I tried searching in previous comments and couldn't find the help. Hence posted in the forum.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.