Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
amaaiia
Contributor III
Contributor III

Special character in excel sheet name

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.

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

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]);

View solution in original post

2 Replies
Or
MVP
MVP

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

@amaaiia 

can you share a sample

in qlikview or liksense it work without previous

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉