Field not found ApplyMap Qlik Sense

[jmialoundama]

Hi, 

I create a table mapping  from a CSV file : 

MAP_REGROUPEMENT_CODE:
mapping LOAD
"Regroupement code",
Code
FROM [lib://AttachedFiles/Regroupement_ICA_CODE.csv]
(txt, codepage is 28591, embedded labels, delimiter is ';', msq);

Then i use table map in a table dimension like this :

ApplyMap('MAP_REGROUPEMENT_CODE',Code,'Code non regroupés') as "Regroupement CODE"

I have this error when i load data in script : Field 'Code' not found 

[sunny_talwar · Accepted solution]

Because your field is called ICA_CODE within D_ACCOUNT_ICA.qvd... you need to use that as your mapping field

[ACCOUNT ICA]:
LOAD ICA_CODE,
            ApplyMap('MAP_RGP_CODE', ICA_CODE, 'Codes non regroupés') as "Code groupé"
FROM [$(V_QVD_Lib_Root)/exact_bi/BRUT/$(V_Country_Code)/D_ACCOUNT_ICA/D_ACCOUNT_ICA.qvd](qvd);
EXIT script;

[jmialoundama]

Hi ,

I just found your solution after having carefully analyzed my code.

But thanks in any case for your answer 🙂

[sunny_talwar]

No offence to @jochem_zw , but how was his response different from my response provided above?