topic Re: loop to load multiple excel sheets in QlikView

loop to load multiple excel sheets

josielaidlaw — Sat, 16 Nov 2024 21:18:34 GMT

Hi!

I have a folder on my computer, "Liefermenge," and in it, a folder "Quote." In the quote folder is a number of different files, but I would like to create a loop to load only the ones that start with 0021... (ex. 0021_201901.xlsx, 0012_201902.xlsx, and so on).

How would I go about doing this? I have read the questions similar to this, but I don't understand how to make a loop that selectively loads files from a folder.

I can't share any files, as I am working with Qlikview desktop.

Thanks in advance!

Re: loop to load multiple excel sheets

Vegar — Tue, 05 Mar 2019 06:49:00 GMT

The absolute easiest way to accomplish this is to fetch QlikView component library and use the qvc.listfiles SUB.

https://github.com/RobWunderlich/Qlikview-Components

Re: loop to load multiple excel sheets

hopkinsc — Tue, 05 Mar 2019 07:55:26 GMT

Are the field names the same in each? if so, can't you just use a wildcard?

From 0021*.xlsx

Re: loop to load multiple excel sheets

josielaidlaw — Tue, 05 Mar 2019 07:58:47 GMT

Yes, all the field names are the same.

Where would I put this statement?

Re: loop to load multiple excel sheets

Vegar — Tue, 05 Mar 2019 08:04:50 GMT

Data:
LOAD
Field1, 
Field2,
Measure1,
Measure2
FROM
[..\Quote\0012*.xlsx]
(ooxml, embedded labels, table is Sheet1);

Re: loop to load multiple excel sheets

hopkinsc — Tue, 05 Mar 2019 08:02:27 GMT

In the from clause at the end. So...

table1:
Load
Field 1,
Field2
Etc
>From path\0021*.xlsx;

Re: loop to load multiple excel sheets

josielaidlaw — Tue, 05 Mar 2019 08:06:50 GMT

Thank you!!!