Apply map not working correct

[AIShatiLove]

Hi, Qlik 
i have an issue with my map table and i can't get corret mapping values by using apply map.

i always get  "Others " values  in field "name_of_dealers"
here is my tables (i hid some values)

[edwin]

i think your problem is data type, your mapping load i bet is interpreting the first field (code) as numeric and then in your applymap you are forcing the field as Text.  you can force the data type in the mapping load as well

try that hope it helps

[edwin · Accepted solution]

mappling load text(code) as code, name Inline [
code, name
...