Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
Does your QVD has the field name PRACTICE?
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
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
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.
QlikView 12.xx ?
QlikView 11.xx doesn't bother about non-existent mapping tables. ApplyMap just returns Null.
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.
I am facing the same error.
Any update on this guys?
Strange !! could you share the sample QVD so that we could try ?
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