Batch Macro for iterating location filter

[Nicholas_Kierstead]

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?

[mceleavey]

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.