Loading equally named excelfile from different subfolders qlikview

[jokamoelv227]

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?

[tincholiver]

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