Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 amaaiia
		
			amaaiia
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		I'm trying to read some excel sheets by sheet name. One sheet name is 'a&b', but I get an error.
I try:
(ooxml, no labels, header is 12 lines, table is 'a&b');
But:
The following error occurred:
Unexpected token: '&', expected one of: ',', ')', 'Where', 'While', 'Group'
.......
(ooxml, no labels, header is 12 lines, table is ***>>>>>>&<<<<<<b)How can I read filenames with special characters? I've also tried with chr(38) instead of &, but same error.
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Square brackets should work, I believe:
(ooxml, no labels, header is 12 lines, table is [a&b]);
The following loads correctly:
LOAD
A, B
FROM [lib://AttachedFiles/New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is [A&B]);
 
					
				
		
 Or
		
			Or
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Square brackets should work, I believe:
(ooxml, no labels, header is 12 lines, table is [a&b]);
The following loads correctly:
LOAD
A, B
FROM [lib://AttachedFiles/New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is [A&B]);
 Taoufiq_Zarra
		
			Taoufiq_Zarra
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		can you share a sample
in qlikview or liksense it work without previous
