topic Re: Error using 2 ApplyMap consecutively in QlikView

Error using 2 ApplyMap consecutively

Tue, 11 Sep 2012 11:08:19 GMT

Hi, while I'm loading a table I use ApplyMap to add a new field this way:

  ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID,

So I get the field SupplierID, but If I add a second ApplyMap, this way

 ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID,
ApplyMap('Map_CustVendorName',SupplierID,Null()) AS SupplierName

trying to use the first result (SupplierID) in the second mapping It gives an error while loading the table

Field <SupplierID> Not found.

If I can't do this this way, how can I add later another field to the table previously loaded.

Thanks

Re: Error using 2 ApplyMap consecutively

Tue, 11 Sep 2012 11:20:11 GMT

Hi Pedro,

you cannot use SupplierID field this way, as it is not created yet. You can try with the following:

ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID, ApplyMap('Map_CustVendorName',ApplyMap('MapGestSuppliers',LotNumber,Null()),Null()) AS SupplierName

or create two load statemets, the first one with

ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID

and the second with

ApplyMap('Map_CustVendorName',SupplierID,Null()) AS SupplierName

regards

Re: Error using 2 ApplyMap consecutively

Tue, 11 Sep 2012 11:40:23 GMT

Thanks Krunoslav, I've used the first method and it works for me.