To perfrom Case like operation
Moderators: chulett, rschirm, roy
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".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
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?
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 ...
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>