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
