To perfrom Case like operation

ArndW · Post by **ArndW** » Sat Jul 26, 2008 1:22 am

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".

getsatish_gk · Post by **getsatish_gk** » Sat Jul 26, 2008 1:27 am

It works .. Ohh it was so simple...

-Thanks a lot.

getsatish_gk · Post by **getsatish_gk** » Sat Jul 26, 2008 1:33 am

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 ...

ArndW · Post by **ArndW** » Sat Jul 26, 2008 1:37 am

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.