topic Re: Apply Map doesn't work properly in QlikView

Apply Map doesn't work properly

Sat, 01 Mar 2014 00:56:37 GMT

Please, see the files attached. The field "item_substitute" doesn't match like the Inline table.

Can you guys check out what is wrong??

Sat, 01 Mar 2014 01:10:45 GMT

Hi Julio,

In your application in actual state, you are mapping the field Classifications of table Menu with Food_name of mapping table. This never will match.

If you want to use a mapping table for food:

You should use:

Mapping	LOAD		item_id, Food_name
FROM

First field is the field to map, and second is the result.

And then ApplyMap('Temp',item_id) as item_substitute (Here item_id is the field of Menu table.

Regards.

Sat, 01 Mar 2014 02:31:24 GMT

but Guzmán, try to uncomment the inline tables... See that it's working perfectly... why is it not working when I load it from the .xls file?

Sat, 01 Mar 2014 02:35:02 GMT

pay attention, the only problem is with the hamburguer...

Sat, 01 Mar 2014 02:40:56 GMT

It worked, I rewrote the table in the .xls file and it worked, it was some kind of problem, bug, i don't know. But thank you, alot