Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Load multiple files (Excel)

Dears,

I would like to know how to create a script or anything else to read multiple excel files. The problem is:

Once a month I'll extract an Excel file with more then 60.000 lines. So, I can't consolidate 2 months in one spreadsheet coz excel will only allow me to work with 65.000 lines.

Is is possible to create an script to read all the excel files, example, imagine that I have this files:

DB_values_January.xls
DB_Values_February.xls
DB_values_March.xls
...
DB_values_December.xls

The collumns title and position is the same in those spreadsheets. So, I would like to ask QlikView to read all spreadhsheets starting with "DB_values_" Is is possible? How can I do it?

Thanks in advance per your assistence.

Bye

1 Solution

Accepted Solutions
Highlighted
Not applicable

AW:Load multiple files (Excel)

Hello,

this can rather easy be done with using wildcards in your file-spec similar to this:

Load * From DB_values*.xls (.....


Regards, Roland

View solution in original post

2 Replies
Highlighted
Not applicable

AW:Load multiple files (Excel)

Hello,

this can rather easy be done with using wildcards in your file-spec similar to this:

Load * From DB_values*.xls (.....


Regards, Roland

View solution in original post

Highlighted
Not applicable

AW:Load multiple files (Excel)

Thanks Roland,

It's working perfeclty