Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
I've been supplied an Excel file that has a '$'-sign in a fieldname.
SomeTable:
Load
"Awd $(by X)"
FROM [lib://Excel File From Hell.xlsx]
The core of the issue is that qlik keeps trying to expand the dollar sign, and then not loading the field and sometimes erroring out.
I have attached a demo Excel file in case anyone wanted to try.
Any help is greatly appreciated.
use the no labels keyword
[Sheet1]:
LOAD
[A] as [first column]
FROM [lib://DataFiles/Qlik Test Load.xlsx]
(ooxml, no labels, header is 1 lines, table is Sheet1);
Please like and mark my answer as a solution, if it resolved your issue.
use the no labels keyword
[Sheet1]:
LOAD
[A] as [first column]
FROM [lib://DataFiles/Qlik Test Load.xlsx]
(ooxml, no labels, header is 1 lines, table is Sheet1);
Please like and mark my answer as a solution, if it resolved your issue.