iterate this workflow for multiple filters - macro

[johnnyacm]

Hello community, I must iterate this extensive workflow for 4 cities, at this moment it is doing it for one city but I must repeat it with other filters shown in the image, how can I do it? and also how can I reduce the flow with a macro that contains the entire process
?

Thank you

[Felipe_Ribeir0]

Hi @johnnyacm 

You will need to create a batch macro (i suggest you to take a look here to get a better understanding of it: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros)

Basically, you will pass the City as a parameter, and the macro will filter the dataset for each City individually, execute your ETL for it, and union all results.

Take a look at the attached example and see if it make sense.