Discussion Board for collaboration on QlikView Scripting.
Please, see the files attached. The field "item_substitute" doesn't match like the Inline table.
Can you guys check out what is wrong??
Go to Solution.
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:
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.
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?
pay attention, the only problem is with the hamburguer...
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