Workflow that re-runs with multiple start dates as inputs, one by one

[AlsTricks]

Hi everyone,

I am a working on workflow that is intended to use a set of start dates as inputs for queries.

Let's say that there are seven start dates, and I would like to pass each of them, one by one, into the workflow to act as inputs for the query.

For example, the workflow will first run and finish with 2022-10-01 as the start date input, and then run with 2022-10-02 as the start date input, and then 2022-10-03, and so on.

As part of the workflow, I would like the results of the seven queries to be unioned together at the end.

How could this be achieved in Alteryx please?

Thank you for your support,

Alex

[Clifford_Coon]

Hi @AlsTricks ,

This sounds like a good use case for a batch macro. (at least that's what I'd do)

Feed list of dates into control parameter, and the data stream to macro input.

Here is a link to the Interactive training.

Creating a Batch Macro - Alteryx Community

Happy Solving ;-)

[FrederikE]

Hey @AlsTricks

This sound like the perfect use case for a batch macro. 

In a batch macro, you define an input (via. "Control Parameter") and let this parameter (your date) influence the workflow in the desired way. Then you can send the next date into the wf and let it perform the same thing with the next batch (a date). 

Hope this helps. 

[geraldo]

@AlsTricks 

AN WORKFLOW EXAMPLE

ADJUST THE QUERY AND THE DATABASE

[AlsTricks]

Thanks everyone - I will check out those resources.