topic define default value in applymap/mapping load in QlikView

define default value in applymap/mapping load

Fri, 18 Oct 2013 08:26:02 GMT

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 — Fri, 18 Oct 2013 08:29:28 GMT

Hello,

try with

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

Hope this helps!

Fri, 18 Oct 2013 08:31:34 GMT

Thanks