In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
Free Trial

Alteryx Designer Desktop Discussions

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

Macro with dynamic dates list loop

omkarshinde
8 - Asteroid

I have 7 workflows binded to eachother by macro inputs outputs and the first workflow contains update action date value tool. I want to pass a list of 12 dates that is first date of each month to it now and store every one run output in separate folder

2 REPLIES 2
DanielG
12 - Quasar

@omkarshinde - those dates are pretty standard, so why would you need to pass them around.  The first day of each month will always be the first day of each month (obviously +/- year value).  You should be able to just build that into a text input or a formula to produce the 12 days in each workflow needed without having to share that information in between.  Seems like an unneeded level of complexity based on what you have written, though I could be misunderstanding your question as there isnt much detail there.  :)

omkarshinde
8 - Asteroid

@DanielG I am being slightly misunderstood here. After every date is passed once through the 7 consecutive workflows which are binded as macro inputs and macro outputs connections; these outputs would be stored in one single folder ex-2023-01-01_outputs consisting of 7 output files.
Now, after this I want next date that is 2023-02-01 to be passed generating similar process and outputs.
Hope I am clear now.

(P.S in case you are wondering why the dates and outputs need to be automated it is because the entire process consists of 21 date changes for one date which becomes a hassle)

Labels
Top Solution Authors