Skip to Content
0
Sep 23, 2020 at 06:53 PM

Multiple Lookup's in One Decode

142 Views Last edit Oct 27, 2020 at 11:57 PM 2 rev

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.