Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The following script is throwing error as - Error: File extdata.cpp, Line 2903.
What could be the solution to this.
CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;Data Source=open.xlsx;Extended Properties="Excel 8.0;"];
tables:
SQLtables;
DISCONNECT;
FOR i = 0 to NoOfRows('tables')-1
LET vsheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));
Sheets:
LOAD *,
'$(vsheetName)' as Sheet
FROM
[open.xlsx]
(ooxml, embedded labels,Table is [$(vsheetName)]);
NEXT
DROP TABLE tables; // The table list is no longer needed
Have a look at your document log it should give you more details on the error.
You will need to select Generate Logfile in the Document Properties and then reload again. The logfile is saved the the same folder as your QVW.
When does this happen? When you start Load Script execution? When the reload engine executes a specific statement (which statement)? At the end of your script when synthetic keys are being created?
Note that error messages like this point to a bug in the software. You may want to contact Qlik Support for assistance.
Best,
Peter