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