We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

looping through analytic app

doublej
7 - Meteor

I have a workflow that is set up as an analytic app so that a date is chosen via a date selector and details from the chosen date are returned.  Now i have a need to run multiple dates worth of data.  The data is such that is has to look at conditions that existed on each specific reporting day so i cant run for a period and summarize.  is there a way to "loop" through the app while changing the effective date each loop?

 

Unfortunatley i cant post the workflow, contains customer data.

3 REPLIES 3
patrick_digan
17 - Castor
17 - Castor

A batch macro should do the trick. @michael_treadwell explains them on his blog post. I'm not sure the best way to have a user select multiple dates for input though if you're getting the dates from the user. You would need a control parameter in your batch macro and in your module you would pass the date selections (1 in each row) into your batch macro's upside down ? input.

 

Let me know if you run into any problems! Batch macros aren't intuitive at first.

dataMack
12 - Quasar

I think a batch macro may be the best choice, but the Runner macros in the Crew macro pack might also work for this situation

doublej
7 - Meteor

@patrick_digan wrote:

A batch macro should do the trick. @michael_treadwell explains them on his blog post. I'm not sure the best way to have a user select multiple dates for input though if you're getting the dates from the user. You would need a control parameter in your batch macro and in your module you would pass the date selections (1 in each row) into your batch macro's upside down ? input.

 

Let me know if you run into any problems! Batch macros aren't intuitive at first.


 

this was very helpful, exaclty what i needed.  was able to supply a list of dates and it looped through.  Thanks!

Labels
Top Solution Authors