Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Data:
LOAD Field1, Field2, Measure1, Measure2 FROM [..\Quote\0012*.xlsx] (ooxml, embedded labels, table is Sheet1);
Are the field names the same in each? if so, can't you just use a wildcard?
eg
From 0021*.xlsx
Yes, all the field names are the same.
Where would I put this statement?
Data:
LOAD Field1, Field2, Measure1, Measure2 FROM [..\Quote\0012*.xlsx] (ooxml, embedded labels, table is Sheet1);
Thank you!!!