topic apply map error in QlikView

apply map error

capriconuser — Fri, 02 Aug 2019 09:04:01 GMT

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);

Re: apply map error

capriconuser — Fri, 02 Aug 2019 09:04:42 GMT

this shows an error

Field not found error

Field 'KEY_name' not found

Re: apply map error

srg99999 — Fri, 02 Aug 2019 09:15:28 GMT

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

Re: apply map error

capriconuser — Fri, 02 Aug 2019 09:19:42 GMT

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

Re: apply map error

tresB — Fri, 02 Aug 2019 09:41:08 GMT

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.

Re: apply map error

capriconuser — Fri, 02 Aug 2019 09:52:28 GMT

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

Re: apply map error

tresB — Fri, 02 Aug 2019 09:58:53 GMT

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