Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]);
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]);
can you share a sample
in qlikview or liksense it work without previous