topic Re: Apply Mapping question in QlikView

Apply Mapping question

vikasmahajan — Wed, 08 May 2013 09:20:43 GMT

Dear All,

Find attachment of qvw can any one help me to achive APPLY MAP function , I want to add base division in transaction table.

Thanks

Vikas

giakoum — Wed, 08 May 2013 09:30:26 GMT

prodmast:

mapping LOAD [Product Code],

[Base Divison]

FROM

testdata.xlsx

(ooxml, embedded labels, table is PRODMAST);

trn:

LOAD [Invoice No],

[Invoice Date],

[Product Code] as prod,

Product,

Division,

[Invoice Qty],

[Bonus Qty],

[Gross Sales Amt],

ApplyMap('prodmast', [Product Code]) AS BaseDiv

FROM

testdata.xlsx

(ooxml, embedded labels, table is Sheet1);

vikasmahajan — Wed, 08 May 2013 09:33:31 GMT

Thanks