Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
6 - Meteoroid

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
6 - Meteoroid

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
6 - Meteoroid

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