topic Loading multiple tabs in the Excel in QlikView

Loading multiple tabs in the Excel

Tue, 07 Feb 2012 10:30:08 GMT

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..

Loading multiple tabs in the Excel

Jason_Michaelides — Tue, 07 Feb 2012 10:43:27 GMT

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

Data:

LOAD A,

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,

FROM

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

Next;

Hope this helps,

Jason

Loading multiple tabs in the Excel

kuba_michalik — Tue, 07 Feb 2012 10:58:59 GMT

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,

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.

Loading multiple tabs in the Excel

erichshiino — Tue, 07 Feb 2012 11:02:52 GMT

Hi,

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

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

Regards,

Erich