Automatically process workflow with filter to output a sheet with every possible option

Question

I have a workflow which involves a filter based on a column with a discrete number of options (~16). I would like to process the workflow so that rather than manually change the filter and re-run the workflow, I can just run the workflow once and have the output be a file with 16 tabs, labelled by each option in the filter.

I feel like in theory this should be a pretty simple process, but I've struggled to find a solution online / leverage the macro tools appropriately. Key callout, this is a rather complex workflow that I'd rather not start from scratch / optimize in any way beyond simply having this one filter "cycle". Thanks!

griffinwelsh · Answer

@George221 Did you look at the batch macro I posted? You just need to feed in your data and feed in a unique list of filters to get your desired output. I recommend this tutorial for batch macros https://www.youtube.com/watch?v=NNH_K5U5r78

George221 · Answer

This would work if the filter wasn't already part of a fairly complicated workflow - I can't exclude the filter to do what you'd suggest. I think a simple macro solution is essentially all that's needed, but I have no idea how to functionally accomplish that. Feel like documentation / tutorials for Alteryx I've found in general have been pretty user-unfriendly / hard to understand.

George221 · Answer

I understand this in theory (and knew there must be a macro method), but not in practice. Any YouTube tutorials you'd recommend just to jumpstart my thinking? Any I've watched have been pretty unhelpful.