Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic Input Yesterday's Output

cro159
7 - Meteor

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
7 - Meteor

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
7 - Meteor

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
Top Solution Authors