topic Re: ApplyMap doesn't work: why? in Data Movement & Streaming

ApplyMap doesn't work: why?

AA240197 — Wed, 19 Mar 2025 22:11:20 GMT

Hi guys, I have this script to have as output a text field present in the mapping table:

In your opinion, there are mistakes. Because I've really tried everything, but the applymap always gives me the Null.

I tried to copy and paste the table (inline) and instead it takes the values. So, I wonder, what could be the problem?

Mapping map1: LOAD codcausale, specifcaus; SELECT "vsql_id", "vsql_pk", "codcausale", "specifcaus", "desccaus", "codreg", "causautom", "mastro_iva", "conto_iva", "sottoc_iva", "tipodoc_telematico_fatture", "scritture_provvisorie", "vsql_user_ins", "vsql_user_ultmod", "vsql_dataora_ins", "vsql_dataora_ultmod" FROM "okw"."tabcausa"; Giornale: LOAD vsql_id, vsql_pk, vsql_annocontabile, codcausale, codregcont, protocollo, datareg, numdoc, datadoc, descriz, numpartita, applymap('map1', codcausale, null()) as New; SELECT "vsql_id", "vsql_pk", "vsql_annocontabile", "codcausale", "codregcont", "protocollo", "datareg", "numdoc", "datadoc", "descriz", "numpartita" FROM "okw"."giornale";

(Codcausal is a text type field)

Re: ApplyMap doesn't work: why?

theoat — Wed, 20 Mar 2024 16:45:04 GMT

The good syntaxe is
map1:
Mapping Load

Not
Mapping
map1:
Load

So you can try this :

map1: Mapping LOAD codcausale, specifcaus; SELECT "vsql_id", "vsql_pk", "codcausale", "specifcaus", "desccaus", "codreg", "causautom", "mastro_iva", "conto_iva", "sottoc_iva", "tipodoc_telematico_fatture", "scritture_provvisorie", "vsql_user_ins", "vsql_user_ultmod", "vsql_dataora_ins", "vsql_dataora_ultmod" FROM "okw"."tabcausa"; Giornale: LOAD vsql_id, vsql_pk, vsql_annocontabile, codcausale, codregcont, protocollo, datareg, numdoc, datadoc, descriz, numpartita, applymap('map1', codcausale, null()) as New; SELECT "vsql_id", "vsql_pk", "vsql_annocontabile", "codcausale", "codregcont", "protocollo", "datareg", "numdoc", "datadoc", "descriz", "numpartita" FROM "okw"."giornale";

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: ApplyMap doesn't work: why?

PhanThanhSon — Wed, 20 Mar 2024 16:44:36 GMT

Hi,

try this:

map1: Mapping LOAD codcausale, specifcaus; SELECT "codcausale", "specifcaus" FROM "okw"."tabcausa"; Giornale: LOAD vsql_id, vsql_pk, vsql_annocontabile, codcausale, codregcont, protocollo, datareg, numdoc, datadoc, descriz, numpartita, applymap('map1', codcausale, null()) as New; SELECT "vsql_id", "vsql_pk", "vsql_annocontabile", "codcausale", "codregcont", "protocollo", "datareg", "numdoc", "datadoc", "descriz", "numpartita" FROM "okw"."giornale";

Best regards Son

Re: ApplyMap doesn't work: why?

AA240197 — Wed, 20 Mar 2024 16:44:55 GMT

Thank You!

I fixed it as you suggested, but it still doesn't work properly. That is absurd, because if I create the same table with the INLINE command, copying and pasting the two fields, the mapping works.

map1: Mapping LOAD codcausale, specifcaus; SELECT "vsql_id", "vsql_pk", "codcausale", "specifcaus", "desccaus", "codreg", "causautom", "mastro_iva", "conto_iva", "sottoc_iva", "tipodoc_telematico_fatture", "scritture_provvisorie", "vsql_user_ins", "vsql_user_ultmod", "vsql_dataora_ins", "vsql_dataora_ultmod" FROM "okw"."tabcausa"; Tabella1: LOAD vsql_id, vsql_pk, vsql_annocontabile, // codcausale, codregcont, protocollo, datareg, numdoc, datadoc, descriz, numpartita, ApplyMap('map1', codcausale, 'nessuno') as New; SELECT "vsql_id", "vsql_pk", "vsql_annocontabile", "codcausale", "codregcont", "protocollo", "datareg", "numdoc", "datadoc", "descriz", "numpartita" FROM "okw"."giornale";

Re: ApplyMap doesn't work: why?

theoat — Wed, 20 Mar 2024 16:46:42 GMT

Add noconcatenate before the creation of your mapping table.

Re: ApplyMap doesn't work: why?

AA240197 — Wed, 20 Mar 2024 18:18:46 GMT

Very kind.

Can you please confirm that I have well understood the position of the noconcatenate?

map1:

Mapping

LOAD

codcausale,

specifcaus;

FROM "okw"."tabcausa";

NoConcatenate

Tabella1:

LOAD

vsql_id,

vsql_pk,

vsql_annocontabile,

// codcausale,

codregcont,

protocollo,

datareg,

numdoc,

datadoc,

descriz,

numpartita,

ApplyMap('map1', codcausale, 'nessuno') as New;

SELECT "vsql_id",

"vsql_pk",

"vsql_annocontabile",

"codcausale",

"codregcont",

"protocollo",

"datareg",

"numdoc",

"datadoc",

"descriz",

"numpartita"

FROM "okw"."giornale";

Re: ApplyMap doesn't work: why?

AA240197 — Thu, 21 Mar 2024 09:50:45 GMT

I removed the "mapping" statement, using a drop table at the bottom, and that's the only way it works at the moment.

I used the exact same logic with two other mapping tables and no problem. This one, on the other hand, does not want to know anything about working in the traditional way.

Re: ApplyMap doesn't work: why?

Adam_Romanowski — Thu, 21 Mar 2024 11:00:10 GMT

Try to remove semicolon from mapping load:

map1:

Mapping

LOAD

codcausale,

specifcaus

FROM "okw"."tabcausa";

and I'm not sure, but applymap checks for data types. If you have codcausale in map1 loaded as text (interpreted by Qlik) and codcausale in Tabella1 as number, applymap may fail. But firstly, remove semicolon.

Re: ApplyMap doesn't work: why?

AA240197 — Fri, 22 Mar 2024 08:37:27 GMT

Thank you for your reply.

I removed the mapping statement and everything seems to be working properly.

I wonder, once a mapping is set up, to add other mappings (a second, third and so on) it is necessary to repeat the "mapping" command or can Qlik read it by itself, if the mappings are consecutively columned?

Re: ApplyMap doesn't work: why?

marcus_sommer — Fri, 22 Mar 2024 08:46:39 GMT

Each mapping table needs a separate mapping statement and will create an own independent table which are automatically removed when the script has finished.

There is no limitation how many mapping tables are created.