Loading equally named excelfile from different subfolders qlikview

jokamoelv227 — Sat, 16 Nov 2024 21:16:24 GMT

Hi,

I'm struggeling with the following scenario:

I have a main folder containing 70 different subfolders. In each of these subfolders there is a folder named Metadata. The metadata folder contains an excelfile named Mapping.xlsm.

Is there a way to loop through this hierarchy of folders and reading the Mapping.xlsm excel from each and everyone of them?

The first thing that came to me was to try to use For each File in filelist and then specify the main folder in the filelist. Should I then invoke another for each file in filelist to go through the hierarchy of the subfolders?

Re: Loading equally named excelfile from different subfolders qlikview

tincholiver — Mon, 11 Mar 2019 14:11:50 GMT

Here you have a posiible solutios, it's dependens how you named each file:
FOR i=01 to 12
Table:
LOAD *
FROM $(Data)yourxlsm_$(i).csv(txt, utf8, embedded labels, delimiter is ',', msq);
NEXT i
this scrip in my case reload csv files from the diferents months (jan-Dec).

Let me know if help you this way, if not please share a picture of how the files are named and what is your expected result

topic Loading equally named excelfile from different subfolders qlikview in QlikView

Loading equally named excelfile from different subfolders qlikview

Re: Loading equally named excelfile from different subfolders qlikview