Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I am having months data in the Excel Sheet.
Every month it will added one more Sheet With new month, need to be loaded in a Single load dynamically.
Please find the attached excel, Can any help me on this..
Regards,
Helen
Helen,
Let vXLSPath='PathToFileIncludingFilename.xlsx';
ODBC CONNECT TO [Excel Files;DBQ=$(vXLSPath)];
Sheets:
SQLTABLES;
DISCONNECT;
for i = 0 to FieldValueCount('TABLE_NAME') -1
Let vTablename = Left(Peek('TABLE_NAME',$(i)),len(Peek('TABLE_NAME',$(i)))-1);
Data:
LOAD *
FROM
$(vXLSPath)
(ooxml, embedded labels, table is [$(vTablename)]);
Next i;
DROP Table Sheets;
Hi Andrew Walker - I'm getting an error for the ODBC connection. I'm on Qlik Sense Enterprise....Do you know what it could be out of chance? ;
The following error occurred:
CONNECTs other than LIB CONNECT are not available in this script mode.