This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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
LOADfrom $(file)(qvd);End If;
Load * from [lib:/yourlibrary/Daily*$(vYear)*];
@nakuldev refer below