Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Apply Map error:map_id not found

I get "Apply Map error:map_id not found" when I run the below script. What am I doing wrong? I want to replace the longer name (PRACTICE) with the shorter name (ShortPractice) but otherwise use the current name.

Practices:

Mapping LOAD * INLINE [

PRACTICE, ShortPRACTICE

Basic Materials, Materials

Corporate Professional Services, CPS

'Equipment, Engineering and Construction', EEC

Human Resources, HR

Industrial and MRO, I&MRO

IT/Telecom, IT/T

UNCATEGORIZED, Uncat

];

Contracts:

LOAD

     ApplyMap('Practices',PRACTICE,PRACTICE) as PRACTICE

FROM

[QVD-Generators\CSW\CSW.qvd]

(qvd);

1 Solution

Accepted Solutions

Re: Apply Map error:map_id not found

As a debugging exercise:

1. Remove the "Mapping" prefix from the script.

2. Place an "Exit Script;" statement after the load of the "Practices" load and then reload.

Does the "Practices" table appear in the table viewer?

-Rob

18 Replies
vishsaggi
Esteemed Contributor III

Re: Apply Map error:map_id not found

Does your QVD has the field name PRACTICE?

Not applicable

Re: Apply Map error:map_id not found

Hi Ed,

I tried to recreate ApplyMap error: map_id not found this is coming for me only when I give wrong mapping table.
Could you please cross check in your script once whether mapping table name is exactly the same as the Applymap() mentioned

nikhil_deokar
New Contributor

Re: Apply Map error:map_id not found

Hey Ed,

First you check whether the PRACTICE field exists in qvd or not

if exists then write the following syntax:-

ApplyMap('Practices',PRACTICE,Null()) as ShortPRACTICE



Regards

Nikhil Deokar

Not applicable

Re: Apply Map error:map_id not found

Vishwarath - Yes, the QVD does have PRACTICE as a field

Ravindra - I don't understand your question, you can see above that I named the inline table Practices

Nikhil - Replacing non-matching fields with a null does not make a difference, besides that's not what I want to do.

Re: Apply Map error:map_id not found

QlikView 12.xx ?

QlikView 11.xx doesn't bother about non-existent mapping tables. ApplyMap just returns Null.

Re: Apply Map error:map_id not found

Just answering my own question. This error message has been introduced in QV12.10IR (What a pity!!!)

If the Mapping table does exist at the time of the ApplyMap call, you've probably hit a bug of some sorts. If nothing helps, better contact Qlik Support.

amanjain57
Contributor

Re: Apply Map error:map_id not found

I am facing the same error.

Any update on this guys?

Re: Apply Map error:map_id not found

Strange !! could you share the sample QVD so that we could try ?

nareshguntur
Valued Contributor

Re: Apply Map error:map_id not found

Ed

One possible reason I could think of is

The name "Practices"(Mapping table name)... can you cross check whether you are using the same name in the apply map as well(case sensitive)

Naresh