Loading multiple tabs in the Excel

[#1]

Hi All,

      I have 12 sheets of data for 12 months  for a year.. Instead of loading data from different sheets and later concatinating them is there any way that i can load the data from all the sheets with in a single load statement...

Thanks  in advance..

[Jason_Michaelides]

FOR each i IN 1,2,3,4,5,6,7,8,9,10,111,12

Data:

LOAD A,

     B

FROM

yourfile (ooxml, embedded labels, table is Sheet$(i));

Next;

If your Excel doc is 2003 format then change to BIFF and add $ at end:

Data:

LOAD A,

     B

FROM

yourfile (biff, embedded labels, table is Sheet$(i)$);

Next;

Hope this helps,

Jason

[kuba_michalik]

In addition, if the sheets are more "creatively" named you can account for that either by listing them beforehand:

SET sheets = sheetA, sheetB, sheetC

FOR each sheet IN $(sheets)

Data:

LOAD A,

B

FROM

yourfile (biff, embedded labels, table is $(sheet)$);

NEXT SHEET

or even load the list directly from excel file by connecting to it through oledb.

[erichshiino]

Hi,

You may also create an ODBC connection to loop through all the sheets:

http://community.qlik.com/message/165185#165185

Regards,

Erich