We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Taking data from the most recent folder

Luk88kk
8 - Asteroid

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?

1 REPLY 1
ShankerV
17 - Castor

Hi @Luk88kk 

 

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

 

ShankerV_0-1675158821913.png

 

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

 

Labels
Top Solution Authors