Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
isha11bansal
Contributor
Contributor

load concatenated files from latest folder

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

0 Replies