Load multiple Excel-Files with multiple Sheets

[#1]

Hello Community,

i searched for this context and got many results with the "For" Loop. The problem is that i cant adapt that because of my lack in programming skills. So what i wanted to ask is the possibility of Loading Data with the same "Header" from different Sheets/Files.

Example:

i have 2 Excel Sheets with same name, except the numbers at the end:

- Data_02.xls

- Data_33.xls

They all got the same header, so right now iam doing 2 times:

LOAD [ColumnA1],

          [ColumnA2],

          ...

FROM

(ooxml, embedded labels, table is [detail]);

LOAD [ColumnA1],

          [ColumnA2],

          ...

FROM

(ooxml, embedded labels, table is [detail]);

Is there a possibility to simply put the same "Load-statements" on one "FROM-Statement" ?

for excample:

FROM

,

(ooxml, embedded labels, table is [detail]);

Thanks in advance !

[m_woolf]

try:

Data_*.xlsx

[miguelbraga]

Try this:

Example:

Load * From [C:\...\Data_*.xlsx] (ooxml, embedded labels, table is [detail]);

This should do the trick

Regards,

MB

[Oleg_Troyansky]

Loading from multiple excel file is easier - you can simply use a wildcard, like others suggested.

Loading the same data format from multiple worksheets is a bit trickier. If the number of worksheets is large or unknown, the only way is to connect to your Excel spreadsheet via ODBC (yes, there is a special ODBC driver for Excel!), get the list of the existing tables using the ODBC command SQLTABLES and then process the multiple tables one by one.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView an...