on 2020 Sep 23 7:53 PM
Hi Experts,
I got a requirement to write two lookup's in one Decode statement. Can you please confirm is it possible in CPI-DS? When i am writing the 2 lookup's in one decode it is saying, 2nd lookup is not lookup table doesn't exists in the datastore but it exists.
Decode ((TYPE = 'X'), (lookup()),
(TYPE = 'Y'), (lookup()),
'123')
Can you please share an examples for the above.
Thanks & Regards,
Nagaraju.
Request clarification before answering.
Hi Nagaraj,
I tried the same and when I use different lookup tables I was getting the same issue as above but when I use the same lookup table there was no issue and I assume this is a limitation.
with different tables :
With same tables :
we can use below method to achieve the above logic(for different lookup tables) :
1'st transform - Decode(TYPE = X, lookup(), TYPE)
2'nd transform - Decode (TYPE = Y, lookup(), '123').
Regards,
Sibi Sivakumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
58 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.