Apply Map doesn't work properly

[#1]

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

Can you guys check out what is wrong??

[#2 · Accepted solution]

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.

[#3]

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?

[#4]

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

[#5]

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