how to make applymap not to do any action based on my scenario

[#1]

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.

[tresesco]

Have you tried this ?

applymap('Inact_fg',CustID) as flag

[CELAMBARASAN · Accepted solution]

Hi,

You have to use default parameter as CustID

ApplyMap('Inact_fg',CustID, CustID)

[tresesco]

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.

[CELAMBARASAN]

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

[#6]

You're right Chilambu, thanks