ApplyMap is giving common value instead of mapping value?

[that_anonymous_guy]

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

[marcus_sommer · Accepted solution]

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

[that_anonymous_guy]

thanks..it worked