Load order newest to oldest file

[Berg_127]

Hi Qlik Community,

I am new to QlikView and require some assistance with the following:

We receive daily files from one of our clients. Each Excel file contains a file date (YYYYMMDD). I would like to model to import all data from these file but the load order should be the latest file (ie today's file) to the oldest file. 

Only distinct records should be loaded.

Thanks team. 

[AshutoshBhumkar]

Hello,

Why it is needed to load the data in sequential manner. Even if you load the data using * in the end of filename all the files will be loaded into the Qlik sense app.

Or, if you want to load only today's file, you can store a variable with today's date and pass that variable in filename while loading the data. like From Filename_$(vTodayVariable).xlsx.

Please correct if I understood it incorrectly.

Thanks,
Ashutosh

[Berg_127]

Hi Ashutosh,

Many thanks for the message.

The reason for loading from newest to oldest is to ensure that the latest  record changes are reflected.

The distinct record loading is on the unique ID to ensure that the file only reflects unique records taking into consideration the latest changes.

Hope it clarifies your question.