New to Qlik Sense

[isha11bansal]

Hi,

I'm new to Qlik Sense and stuck with an issue. 

I'm connected to a network drive. And there are multiple folders in that drive such as: 

20210831 - Folder 1

20210831_XML - Folder 2

20210830_XML- Folder 3

Inside each folder, there are multiple files as below:

20210831 - Folder 1

         ---> ASWWorkExtract_AU_Open_20210831005454.csv                      (File 1)

       ---->ASWWorkExtract_AU_Resolved_20210831005454.csv                (File 2)

       ---->ASWWorkExtract_AU_Open_CustomFields_20210831005454.csv    (File 3)

So, I'm trying to load 'File 1' and concatenate 'File 2' from the latest folder  which is Folder 1 - '20210831' in my case. 

Basically I'm looking to select the latest folder first and then select two files (File 1 and File 2) from that folder. 

This will help me to automatically load excel files once a new folder is created on the next date. 

Please help. 

Thanks