Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pls give syntex for given below question

what is syntex and process for loading multiple excel sheets in single script..........................................................................................................................................................................pls write one senario at below for understanding purpose

1 Reply
MK_QSL
MVP
MVP

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;