Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Dynamic Input Yesterday's Output

cro159
5 - Atom

I am trying to input my output file from yesterday but want to have a dynamic parameter to where when I run the workflow, the input file is always the file that was run yesterday.  If the file name contains the date, would it be something similar to pull file name today's date minus 1 day?

5 REPLIES 5
chukleswk
11 - Bolide

I use something like this flow to do that. The green block before the last Browse tool is a macro that loops through and loads all of data from those files that you are passing forward.

Yesterday's output.PNG

cro159
5 - Atom

Thanks for the response!  Does that green block line up with one of these tools?

cro159_0-1660143111329.png

 

chukleswk
11 - Bolide

No, it's a macro I created. I have attached it here:

cro159
5 - Atom

Thank you for your help!

chukleswk
11 - Bolide

Not a problem. If this works for you, please mark it as a solution so that others may find it!

Labels