Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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") 😉