Apply Mapping question

[vikasmahajan]

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 · Accepted solution]

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]

Thanks