Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

19 Replies
vishsaggi
Champion III
Champion III

Does your QVD has the field name PRACTICE?

Not applicable
Author

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
Partner - Contributor
Partner - Contributor

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
Author

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.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

QlikView 12.xx ?

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Creator II
Creator II

I am facing the same error.

Any update on this guys?

avinashelite

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

NareshGuntur
Partner - Specialist
Partner - Specialist

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