Dyanamic load of excel files based on year from folder

[nakuldev]

Hi All,

I need to load excel files dynamically from the folder based on year. The name of excel file ends with date (daily basis) and the below image is for reference.

In the folder I have files for 2020 as well, however I need to restrict the files ending with 2020 while loading. As the current year is 2021, I need to load only files ending with 2021.

Thanks for the support in advance

Nakul

[ArinaRay]

Hi, @nakuldev 

You can try

let folder = 'Your_path';

for each file in FileList('$(folder)/*.qvd')
let file_name = SubField('$(file)', '/', -1);

if index('$(file_name)', '2021') > 0 then

LOAD
from $(file)
(qvd);

End If;

next file;

[menta]

let vYear=Year(Today());

Load * from [lib:/yourlibrary/Daily*$(vYear)*];

[Kushal_Chawda]

@nakuldev  refer below

https://community.qlik.com/t5/Documents/Dynamically-Loading-Multiple-Excel-Files/ta-p/1479021