Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I am new to Qlik and I am stuck with ApplyMAp. Could anyone provide me with a solution to this?
People:
Mapping LOAD Region,
Person
FROM
[C:\Users\Downloads\Global Superstore.xls]
(biff, embedded labels, table is People$);
Return:
Mapping LOAD [Order ID],
Returned
FROM
[C:\Users\Downloads\Global Superstore.xls]
(biff, embedded labels, table is Returns$);
Orders:
LOAD [Row ID],
[Order ID],
[Order Date],
[Ship Date],
[Ship Mode],
[Customer ID],
[Customer Name],
Segment,
City,
State,
Country,
[Postal Code],
Market,
Region,
ApplyMap('People',Region) as Manager ,
[Product ID],
Category,
[Sub-Category],
[Product Name],
Sales,
Quantity,
Discount,
Profit,
[Shipping Cost],
[Order Priority],
ApplyMap('Return',[Order ID]) as Returned
FROM
[C:\Users\Downloads\Global Superstore.xls]
(biff, embedded labels, table is Orders$);
I am using two mapping tables. I am getting the desired output with the People table but with Return table it is giving me [Order ID] instead of Returned.
Please let me know if additional information is required.
Thanks
You don't have specified the third parameter from applymap() and therefore it used the second parameter for it. Better is therefore usually to apply an own parameter, like:
ApplyMap('Return',[Order ID], 'no match')
In regard why the matching didn't work take a look if you really load and compares the right fields and if they have the right values, for examples lookup-values as numbers won't match with string-values within the mapping-table.
- Marcus
You don't have specified the third parameter from applymap() and therefore it used the second parameter for it. Better is therefore usually to apply an own parameter, like:
ApplyMap('Return',[Order ID], 'no match')
In regard why the matching didn't work take a look if you really load and compares the right fields and if they have the right values, for examples lookup-values as numbers won't match with string-values within the mapping-table.
- Marcus
thanks..it worked