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.
Mapping LOAD * INLINE [
Basic Materials, Materials
Corporate Professional Services, CPS
'Equipment, Engineering and Construction', EEC
Human Resources, HR
Industrial and MRO, I&MRO
ApplyMap('Practices',PRACTICE,PRACTICE) as PRACTICE
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?
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
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
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.
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.
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)