apply map error

[capriconuser]

I am trying to apply map but this shows an error

RATE_MAP:
Mapping LOAD
KEY_name,
RATE
FROM
[..\Data\Data Received\ab_file.xlsx]
(ooxml, embedded labels, table is Sheet3);

TEMP:
LOAD PRODUCT,
ID,
ApplyMap('RATE_MAP',KEY_name)as AA_RATE

FROM
[..\Data\Data Used\abc.xlsx]
(ooxml, embedded labels, table is Sheet2);

[capriconuser]

this shows an error

Field not found error

Field 'KEY_name' not found

[srg99999]

Hi,
The column in temp table should have the same data type as the KEY_name filed as you are trying to match the KEY_name.
Just cross check the data types of PRODUCT and ID i.e Whichever the field you are using to match

[capriconuser]

when i comment the product and id then still error is display

[tresesco · Accepted solution]

TEMP:
LOAD PRODUCT,
ID,
ApplyMap('RATE_MAP',KEY_name)as AA_RATE

FROM
[..\Data\Data Used\abc.xlsx]
(ooxml, embedded labels, table is Sheet2);

When you write this, qlik expects a field 'KEY_name' in abc.xlsx file. Probably your file doesn't have such field. So you have to correct the field name in applymap(). In applymap you don't have to mention the field name from a mapping table, only map table name is enough.

[capriconuser]

but i apply map from rate _table  not temp  table .. so is it necessary to have key_name in  abc file ? 

[tresesco]

Read it here: applymap() to understand how it works.