Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Batch Macro for iterating location filter

Nicholas_Kierstead
6 - Meteoroid

We have a very large logic flow that filters by the Sate field in our records. Currently we run the report and modify a User.variable to set the state for multiple filters in the flow. If there a way to use batch macro to iterate the state location so it will iteratively run the entire flow based on the list of state we want to iterate?

1 REPLY 1
mceleavey
17 - Castor
17 - Castor

Hi @Nicholas_Kierstead ,

 

yes, you simply feed in the data to a batch macro. Separate out the state field and run it through a group by on the Sum tool to get unique state values and feed this into the control parameter.

In the macro, set your input tool to just stream in your data and then apply a filter to state. Connect a control parameter to the filter and overwrite the filter value.

This will then run the batch for each state.

 

Below is a useful starting point for batch macros:

 

https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

 

M.



Bulien

Labels