Alteryx Designer Desktop Discussions

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

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

AlsTricks
7 - Meteor

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

4 REPLIES 4
Clifford_Coon
11 - Bolide

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
13 - Pulsar

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
13 - Pulsar

@AlsTricks 

 

AN WORKFLOW EXAMPLE


ADJUST THE QUERY AND THE DATABASE

AlsTricks
7 - Meteor

Thanks everyone - I will check out those resources.

Labels