Load Excel files from multiple Folders

amithmurali — Wed, 16 Feb 2022 19:25:49 GMT

Dears,

I have a Folder which contains subfolders for each month and inside this sub folder, i have excel files for each day. I need to load all the months excel file into one table and save it into QVD in QlikSense. I tried different articles but not able to achieve it.

the Sub folder names are Jan 21, Feb 21 etc and inside the subfolder i have xlsx files one for each day. all the excels have same number of columns and sheet names are same in all the excel files.

Regards,

Amith

Re: Load Excel files from multiple Folders

chris_djih — Thu, 17 Feb 2022 08:47:32 GMT

I haven't time at the moment to give a fully solution, but may this keywords will help you found the solution on your own.
Make a variable (vMonthnames) with all possible month folder names devieded by ',' so you can iterate over then.
Make a nother variable vor the month length. vMonthlenght = 31,28,31,30,...;
using a for Loop (vLoopCounter =1) to (Substringcount($(vMonthnames),',')+1)
within this loop start another loop for vInnerLoopCounter= 1 to subfield(vMonthlenght, ',', vLoopCounter)
your Load statement ...
from ".../$(=Subfield(vMonthnames,',',vLoopCounter))/yourexcelforDay_$(vInnerLoopCounter).xlsx"

topic Re: Load Excel files from multiple Folders in App Development

Load Excel files from multiple Folders

Re: Load Excel files from multiple Folders