define default value in applymap/mapping load

[#1]

Hi all,

I am trying to do something like this.

MapCustomerTable:

Mapping Load

KeyField,

CustName

from Customer.xls;

TransactionTable:

Load

KeyField1,

Applymap('MapCustomerTable',KeyField) as CustName

from.....;

I am getting the right output in some place. But when Keyfield1 is not matching to KeyField, It returns the KeyField1 Instead of null or a CustName.

How can I set default value if some of the key field of main table do not match the key field of Mapping table.

[salto · Accepted solution]

Hello,

try with

applymap('MapCustomerTable',KeyField,'DefaultValue') as CustName

Hope this helps!

[#3]

Thanks