Load a file with a MaxDate

clarachac — Thu, 29 Feb 2024 15:39:48 GMT

Hello,

I have multiple files stocked in a repository by date, for example we have the files : 20240226_XXX and 20240224_XXX ...
But in the same repository I have multiple other files with different names, for example : 20240224_YYY

I want to load the file XXX with the most recent date in my qliksense app.

Re: Load a file with a MaxDate

marksouzacosta — Thu, 29 Feb 2024 15:54:50 GMT

Hi @clarachac ,

There are multiple solutions for this problem and without knowing exactly what you have is hard to give you the best solution. However, I can point you to a good direction.

You can use * character to load files with a common name pattern.
In your case, if the files are QVDs:
LOAD * FROM [*_XXX.qvd](qvd);

This will combine all files where the name ends with "_XXX.qvd".

Now, if you are looking to get ONLY the most recent file (the latest) with that name pattern, then you can do something like this:

For Each vFilename in FileList('lib://MyLib/*_XXX.qvd')

// Do nothing here
Next vFilename

LOAD * FROM [$(vFilename)](qvd); // The loop will return your latest listed file

topic Load a file with a MaxDate in Qlik Automate

Load a file with a MaxDate

Re: Load a file with a MaxDate