Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

to read excel file from latest month and latest date folder

Highlighted
8 - Asteroid

Hello,

 

I have multiple month folders and different dates in the month folders.Im trying to extract the latest month and the latest date from the month folder and lastly the excel files from the subfolder. Based on alteryx community thread it;s possible but issue here is the month folder and sub folder will change for each day and given month.Able to help?

thanks.

 

Month

KLS_0-1583594273804.png

Subfolder

KLS_2-1583594297646.png

 

KLS_3-1583594496168.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

 @KLS  

 

Please watch my YouTube video

https://youtu.be/k5cVUa0Oq70 

 

and read:

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/249... 

 

you're looking for the dynamic input preceded by a directory tool. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid

Hey @MarqueeCrew 

 

Thanks for vids. So basically Ive done up the directory and the dynamic input and still facing the null in my output

KLS_9-1584442285813.png

Here's my overall workflow.

KLS_3-1584441932148.png

 

theres 2 dates on the folder of feb

 

KLS_0-1584441337153.png

KLS_1-1584441417179.png

 

All the filesname i want to include in in the filter

KLS_4-1584441994674.png

Creation Date (Descending)

KLS_5-1584442050358.png

 

First 8 cause there a total of 8 files per day

KLS_6-1584442103355.png

 

and my dynamic input tool

KLS_7-1584442170042.png

KLS_8-1584442235128.png

Hope you can help me on this ! 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Are you available now for a ZOOM meeting?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid

@MarqueeCrew that will be tricky due company policy. Would you need any more information at my end to facilitate this further. if you do please let me know.Need your help urgently, thanks

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Sorry. Without visibility to the data and configuration of the dynamic input, I'm at a loss. I'd like to help, but need to see more. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels