Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help me with below error please?
thanks.
Amelia ,
You can load all those excel sheet in one shot. Please follow my comment here below:
. If an excel file contains multiple sheets wit... | Qlik Community
Thanks,
AS
I have used the below one
tables:
SQLTables;
DISCONNECT;
Tables1:
load
*,
replace(TABLE_NAME,chr(39),'') as NEW
resident tables;
DROP Table tables;
let var=NoOfRows('Tables1');
FOR i = 0 to $(var)-1
let sheetName=subfield(peek('NEW', i,'Tables1'),'$',1);
[$(sheetName)]:
Fact:
LOAD Id
FROM
[..\Source_Conversion\Creditor Meeting Split.xlsx]
(ooxml, embedded labels, table is [$(sheetName)]);
NEXT i
DROP Table Tables1;
STORE Fact into C:\Qlikview\table.qvd (qvd);
Read this.I had a same situation
And does this work?
I used the same. But the problem is it is showing ODBC error. please help how to set this.
send me the code you have used and the error details
Yes it works if you have installed Excel on your publisher machine.