Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is syntex and process for loading multiple excel sheets in single script..........................................................................................................................................................................pls write one senario at below for understanding purpose
ODBC CONNECT TO [Excel Files;DBQ=C:\QlikView\Test.xlsx];
Let vFile = 'C:\QlikView\Test.xlsx';
For i=0 to NoOfRows('ExcelTables')-1
Let vExcelSheet = PurgeChar(PurgeChar(Peek('TABLE_NAME',i,'ExcelTables'),CHR(36)),CHR(39));
LOAD
*,
'$(vExcelSheet)' as SheetName
FROM
$(vFile)
(ooxml, embedded labels, table is [$(vExcelSheet)]);
Next
Drop Table ExcelTables;