topic applymap in QlikView

applymap

Tue, 19 Oct 2010 11:08:44 GMT

Hi ,

I am getting error like "MAPPING requires 2-column input" when i use the below script.

Product:
MAPPING LOAD
SellStartDate,
StandardCost

resident Product;

Load
OrderQty,
OrderQty * ApplyMap('Product',StandardCost,0) as SalesAmount
Resident SalesOrderHeader;

Can anybody look into this .Any help will be highly appreciated.

Regards,

Phani

applymap

Tue, 19 Oct 2010 11:12:58 GMT

Hi,

try it like this:

Product:
MAPPING LOAD
SellStartDate AS X,
StandardCost AS Y

resident Product;

Load
OrderQty,
OrderQty * ApplyMap('Product',<field name that you want to change from current table>) as SalesAmount
Resident SalesOrderHeader;

<field name that you want to change from current table> this is the current field from current table you wish to transform not the field from MAPPING TABLE.

Regards, Miha

applymap

Tue, 19 Oct 2010 11:42:44 GMT

Hi,

Thanks for your Message. Actually i want to calculate Sales amount by using Orderqty*standardCost but both fields are in different tables , and i don't want to join that two tables.I tried your code but getting the same error.

Thanks in Advance,

Regards,

Phani

applymap

johnw — Wed, 20 Oct 2010 01:06:19 GMT

You'll probably also need to name your mapping table something different than the resident table you're loading it from. Call it ProductMap, for instance.

applymap

Anonymous — Wed, 20 Oct 2010 01:11:08 GMT

I always, except "load inline", use distinct in mapping load. It would be:
ProductMap:
MAPPING LOAD DISTINCT
SellStartDate AS X,
StandardCost AS Y
RESIDENT Product;