Solved: QlikSense-Load Excel File with '$'-sign in Fieldna... - Qlik Community

JustinDallas · ‎2023-02-22

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.

E_Røse · ‎2023-02-22

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.

E_Røse · ‎2023-02-22

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.

QlikSense-Load Excel File with '$'-sign in Fieldname