Taking data from the most recent folder

Luk88kk

Hi All,
I would like to ask for your help. I have been struggling with a certain thing for some time now. Namely, I have 4 folders. There are 10 excel files in each. I need the workflow to download my data from the newest folder and skip the others automatically.

The folders are titled:
09.12
16.12
23.12
30.12 

I have tried using the Directory Tool, Sorting Tool, Sample Tool and Dynamic Input configurations, however something is wrong all the time.
Directory Tool shows me 40 files downloaded (10 files from each folder) so it works, but how do I automatically extract only those from the 30.12 folder for further process?

ShankerV

Hi @Luk88kk 

After using the directory tool, you will get the Directory part in the below column.

Use unique tool to get only 4 directory, then find the latest folder and 

Use filter where you sort based on the date which you have.

This will help to read the data's dynamically on the latest date.

Many thanks

Shanker V