Qlik Community

QlikView Documents

Documents for QlikView related information.

Load Multiple excel sheets using For loop

MVP & Luminary
MVP & Luminary

Load Multiple excel sheets using For loop

Hi All,

The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements. 

LET vStartSheetNumber = 1;

LET vEndSheetNumber = 50;

LET vExcelFileName = 'Data';

// Generate Empty table

Data:

LOAD

          '' AS Data.Field1,

  '' AS Data.Field2

AutoGenerate(0);

FOR index = vStartSheetNumber TO vEndSheetNumber

     Concatenate(Data)

     LOAD

          *

     FROM [$(vExcelFileName).xlsx]

     (ooxml, embedded labels, header is 10 lines, table is [Page $(index)]);

NEXT

Note : in my excel file the sheet names are in the patter of Page 1, Page 2, ..... Page n.

Hope this helps others.

Regards,

Jagan.

Labels (1)
Comments
sasiparupudi1
Honored Contributor III

It a bit confusing..are you saying that if the flag value is set then the next 2 below values of the indicator will become the numerator and denominators?

cos

20 and 30 are below 10  and 10 has flag set to 1

0 Likes
sasiparupudi1
Honored Contributor III

It a bit confusing..are you saying that if the flag value is set then the next 2 below values of the indicator will become the numerator and denominators?

cos

20 and 30 are below 10  and 10 has flag set to 1

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2013-07-30 03:58 AM
Updated by: