Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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