Page 1 of 1
Posted: Sat Jul 26, 2008 1:22 am
by ArndW
The INDEX() Function is correct; but use "INDEX(FKPOSSTR_IN.SEC_CODE,'.AX',1)" instead. The "2" that you used tells INDEX to use the 2nd occurrence position, and if it doesn't occur twice then the returned value will always be "0", which equates to "False".
Posted: Sat Jul 26, 2008 1:27 am
by getsatish_gk
It works .. Ohh it was so simple...
-Thanks a lot.
Posted: Sat Jul 26, 2008 1:33 am
by getsatish_gk
Correct, and then based on this I want to perfrom the case statment.
But I think transfrom is not support to handle case function. is it so?
is not then what the equivalent for case statement in DS?
ArndW wrote:The INDEX() Function is correct; but use "INDEX(FKPOSSTR_IN.SEC_CODE,'.AX',1)" instead. The "2" that you used tells INDEX to use the 2nd occurrence position, and if it doesn't occur twice then the ret ...
Posted: Sat Jul 26, 2008 1:37 am
by ArndW
There is no case statement in a Transform stage, you need to use an IF-THEN-ELSE construct. There is a Switch stage that you can look into.