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);
 
					
				
		
 rwunderlich
		
			rwunderlich
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 
					
				
		
 vishsaggi
		
			vishsaggi
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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 
 
					
				
		
 nikhil_deokar
		
			nikhil_deokar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
 Peter_Cammaert
		
			Peter_Cammaert
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		QlikView 12.xx ?
QlikView 11.xx doesn't bother about non-existent mapping tables. ApplyMap just returns Null.
 Peter_Cammaert
		
			Peter_Cammaert
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
		
			amanjain57
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I am facing the same error.
Any update on this guys?
 
					
				
		
 avinashelite
		
			avinashelite
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Strange !! could you share the sample QVD so that we could try ?
 NareshGuntur
		
			NareshGuntur
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
