topic Re: "Apply map Error:map id not found "in version 12 in QlikView

"Apply map Error:map id not found "in version 12

kumar577 — Fri, 15 Nov 2024 23:43:22 GMT

Hi guys,

few days back we upgraded our version of Qlikview 12 to a newer version. This morning when i've gone to reload my script the ApplyMaps aren't working anymore. It comes up with

ApplyMap error:

map_id not found

Can anyone tell me what i should do to bring the ApplyMaps up to date?

Thanks

Re: "Apply map Error:map id not found "in version 12

Vegar — Thu, 29 Oct 2020 06:56:22 GMT

In earlier versions you could use applymap referring to map tables that does not exist without getting a script error. In QV 12.x you don't.

Check your script for your map table and make sure it's is generated correct using 'mapping load' and that your spelling of the map table name is correct inside your applymap().

Re: "Apply map Error:map id not found "in version 12

MayilVahanan — Thu, 29 Oct 2020 07:00:36 GMT

Hi @kumar577

For older version, Qlik doesn't throw any error if mapping id is missed out. But in latest version, you need to declare the mapping table, otherwise it throws error.

So please look into your script and fix it.

Hope it helps

Re: "Apply map Error:map id not found "in version 12

kumar577 — Thu, 29 Oct 2020 07:33:43 GMT

yeah everything seems fine sir .mapping tables are loaded before apply map.

Re: "Apply map Error:map id not found "in version 12

kumar577 — Thu, 29 Oct 2020 07:34:11 GMT

yeah everything seems fine sir .mapping tables are loaded before apply map and names are also correct

Re: "Apply map Error:map id not found "in version 12

Brett_Bleess — Wed, 11 Nov 2020 20:34:19 GMT

@kumar577 Likely going to need to attach the actual script file in this case or the appropriate snippets from the script so folks can check things that way. The only other thing I can give you are the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192

https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-as-an-Alternative-to-Joining/ba-p/1473454

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/Mapping.htm

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/MappingFunctions/ApplyMap.htm

Sorry I do not have anything better for you.

Regards,
Brett

Re: "Apply map Error:map id not found "in version 12

Vegar — Wed, 11 Nov 2020 20:53:15 GMT

Just to rule out the obvious. Can you also confirm that the mapping tables are generated with only two columns and you are using the keyword MAPPING?

Like this.

Map_table:

Mapping Load A, B From source ;