Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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
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.
Hi,
You may also create an ODBC connection to loop through all the sheets:
http://community.qlik.com/message/165185#165185
Regards,
Erich