Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a scenario wherein I don't need to do any action by the applymap. For Instance, am passing CustID in the below example to a mapping load to return a value based on the CustID, if the value does not exists I want the applymap to not do any action ??? I can't use null() also here ..
applymap('Inact_fg',CustID,'Y') as flag
Looking for your help here.
Hi,
You have to use default parameter as CustID
ApplyMap('Inact_fg',CustID, CustID)
Have you tried this ?
applymap('Inact_fg',CustID) as flag
Hi,
You have to use default parameter as CustID
ApplyMap('Inact_fg',CustID, CustID)
Hello Celambarasan Adhimulam,
I think that is redundant. If you don't take the third parameter, the default returned value is the value itself when it does not find a match in the mapping table. Correct me, if i am wrong.
Hi tresesco
Yes you are right. By default it takes the field value as default value if no mapping value found in the mapping table.
I pointed him to use CustID instead of 'Y'.
You're right Chilambu, thanks