Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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