Load script For Each File

Cyriltra — Fri, 10 Jun 2022 08:22:36 GMT

Hi,

i'm loading data from multiple excel file. Each Excel file is a different version (ie: a different date) of a forecast.

I'm using the filename to select the forecast version i want to analyze in qlikview.

Now i have a different file which contains my 2019 data that i want to concatenate to EACH file of my forecast. So when i select my forecast version, i can always compare with 2019 easily.

How should i proceed ?

right now i'm doing:

Data:
LOAD
filename() as filename,
[fields & FC metrics]
FROM
[C:\PATH\*.xlsx]
(ooxml, embedded labels, table is Sheet1)

For each File in filelist ('C:\PATH\')
Concatenate(Data)
LOAD
File.name as filename,
[fields & 2019 metrics]
FROM
[C:\ANOTHER PATH\2019 data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Next File;

that does not work, any idea ?

I understand 2019 will be duplicate for each file and i'm ok with that.

Or maybe with using a "For Each File" statement, is there a way i can loop thru each filename loaded previously and then simply concatenate 2019 data and dynamically change filename ?

Thank you

Re: Load script For Each File

Bill_Britt — Wed, 15 Jun 2022 19:18:55 GMT

Hi,

Take a look at this QVW, it is pulling all files from the directory it is in. This might help you with file gathering.

Bill

topic Load script For Each File in QlikView

Load script For Each File

Re: Load script For Each File