topic Dyanamic load of excel files based on year from folder in App Development

Dyanamic load of excel files based on year from folder

nakuldev — Tue, 30 Nov 2021 18:17:33 GMT

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

Re: Dyanamic load of excel files based on year from folder

ArinaRay — Mon, 19 Jul 2021 14:27:07 GMT

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;

Re: Dyanamic load of excel files based on year from folder

menta — Tue, 20 Jul 2021 08:13:26 GMT

let vYear=Year(Today());

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

Re: Dyanamic load of excel files based on year from folder

Kushal_Chawda — Tue, 20 Jul 2021 09:27:52 GMT

@nakuldev refer below

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