topic Re: Field not found ApplyMap Qlik Sense in App Development

Field not found ApplyMap Qlik Sense

jmialoundama — Sat, 16 Nov 2024 03:11:21 GMT

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

Re: Field not found ApplyMap Qlik Sense

sunny_talwar — Mon, 24 Feb 2020 14:03:07 GMT

Do you have a field called Code in the table where you are using the ApplyMap script?

Re: Field not found ApplyMap Qlik Sense

jmialoundama — Mon, 24 Feb 2020 14:08:15 GMT

Hi,

No i have a field which name "ICA_CODE"

Re: Field not found ApplyMap Qlik Sense

sunny_talwar — Mon, 24 Feb 2020 14:11:37 GMT

Then use that within ApplyMap

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

Re: Field not found ApplyMap Qlik Sense

jmialoundama — Mon, 24 Feb 2020 14:23:15 GMT

I changed the name of the CODE column to DEV in my CSV file.

I reloaded this file in my application and I modified my applyMap this way:

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

I get the error that comes up: Field 'DEV' not found

Re: Field not found ApplyMap Qlik Sense

mfarsln — Mon, 24 Feb 2020 14:27:55 GMT

Hi,

You should use lookup column as second parameter from your base table, not the mapping table.

Re: Field not found ApplyMap Qlik Sense

jmialoundama — Mon, 24 Feb 2020 14:31:33 GMT

MAP_REGROUPEMENT_CODE is then name of my table map

DEV is the column contain differents code

REGROUPEMENT CODE is my key.

Re: Field not found ApplyMap Qlik Sense

sunny_talwar — Mon, 24 Feb 2020 14:53:18 GMT

Can you share the complete script you are using here?

Re: Field not found ApplyMap Qlik Sense

jmialoundama — Mon, 24 Feb 2020 14:55:39 GMT

Yes ,

That is my table mapping (in file xlsx)

[MAP_RGP_CODE]:
mapping LOAD
Regroupement,
Code
FROM [lib://AttachedFiles/Regroupement_ICA_CODE.xlsx]
(ooxml, embedded labels, table is Regroupement_ICA_CODE);

[ACCOUNT ICA]:

load
ICA_CODE,
ApplyMap('MAP_RGP_CODE',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;

Re: Field not found ApplyMap Qlik Sense

jochem_zw — Mon, 24 Feb 2020 14:56:52 GMT

your applymap should be:

ApplyMap('MAP_RGP_CODE',ICA_CODE,'Codes non regroupés') as "Code groupé"

Re: Field not found ApplyMap Qlik Sense

sunny_talwar — Mon, 24 Feb 2020 14:59:18 GMT

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;

Re: Field not found ApplyMap Qlik Sense

jmialoundama — Mon, 24 Feb 2020 15:01:20 GMT

Hi ,

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

But thanks in any case for your answer 🙂

Re: Field not found ApplyMap Qlik Sense

sunny_talwar — Mon, 24 Feb 2020 15:03:17 GMT

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