How to automate loading of new file based on incremental filename

[labo2002]

Hello all,

Good day everyone.

We have a series of reports that will be auto downloaded to a shared folder on a daily basis. We would like to achieve is for Qlik Sense to load the new file with the additional coding. 

The naming of convention of the file will be;

MOC_StaffReport_20200303.csv

MOC_StaffReport_20200304.csv

Wherein the date format is YYYY/MM/DD

Appreciate your assistance on this. 

[JordyWegman · Accepted solution]

Hi Labo,

Do all the files need to be loaded? Because if so, you can use this:

Table:
Load
   *
From [../../MOC_StaffReport_*] (txt);

Loading with a * will make sure that all the files named MOC_StaffReport_ will be loaded.

Jordy

Climber 

[labo2002]

Thanks a lot!