pls give syntex for given below question

Tue, 28 Apr 2015 08:59:55 GMT

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

Re: pls give syntex for given below question

MK_QSL — Tue, 28 Apr 2015 09:03:26 GMT

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)]);

Drop Table ExcelTables;

topic pls give syntex for given below question in QlikView

pls give syntex for given below question

Re: pls give syntex for given below question