Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

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

alteryx date varying inputs

n800702
5 - Atom

 just wanted to see if you could help with an issue I had. I currently have a workflow that extracts the data from the sheet of one excel file and inputs it into the sheet of another. This task is done on a daily basis, and the input file has a filename xxxxxxxxxx_YYYY-MM-DD. (confidential info so cant unfortuantely disclose), but the date changes based on current date, and at the moment for me to run this workflowe, I go into it and change the input file to the file that is the current day. Is there any way to automate this so that alteryx picks up the current day file for copying? 

 

Thank you :)

3 REPLIES 3
Raj
16 - Nebula

@n800702 
use directory tool to get all the sheet names
then apply this filter you will have lates file 
then use dynamic input
this will be automated

mark done if solved.

Raj
16 - Nebula

@n800702 
is this solved?

n800702
5 - Atom

it is not letting me open the attatchment

Labels
Top Solution Authors