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

Question

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

AlsTricks · Answer

Thanks everyone - I will check out those resources.

geraldo · Answer

@AlsTricks

AN WORKFLOW EXAMPLE

ADJUST THE QUERY AND THE DATABASE

PARAMETERDATE.yxzp

FrederikE · Answer

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.