Creating a macro to condense a filtering workflow

[BSmithdubz]

This is in my current workflow:

I'm attempting to build a macro to clean this up a little bit. Pictured are 2 of the 19 workflows I am trying to include in a macro (with the same input file and same three tools to the right being linked to all of them). I'm wondering how I can create a macro that condenses all of these tools that will give me the same output and link properly to the union on the right. Is this possible or should I have a macro with all 19 copies of the tools pictured?

[fmvizcaino · Accepted solution]

Hi @BSmithdubz ,

It is totally possible to create a macro to condense all of that and we can go a step even further.

From my understanding, you have two things changing in your workflow:

1.The [ACA] filter

2. [ACA] formula

And then you want to concatenate everything into the same dataset.

If that is correct, you can use a batch macro that will automatically filter, fill the formula and concatenate everything later on.

I will attach a small example here for you but to understand fully what I'm doing, please check this link where it teaches how to build a batch macro from scratch.

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

https://community.alteryx.com/t5/Alteryx-Designer/Getting-Started-with-Batch-Macros/ta-p/488165

Best,

Fernando Vizcaino