Sequential processing and sequential outputing

[Alteryxuserhere]

Hi All

I have a workflow in mind but am unsure how to build it to achieve the outcome. I am looking to do 2 things:

1. Sort by Product Type 

2. Have each product type enter the next flow separately and export all of that product type.
E.g Product Type A gets transformed and output into Product Type A.csv. Then only product type B gets pushed into the transformation and then outputs a file. Then Product C gets pushed etc.

The challenge is the Product Type column is dynamic and I don't have a predefined set of names i can use for filtering and i am unsure how to set up this sequential rule.

Can someone suggest how I could do it? I have uploaded a rough workflow idea on what I am trying to do. THanks!

[Qiu]

@Alteryxuserhere 
That is indeed a rough workflow. 😁

It seems that we need a batch here.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-macro-that-output-each-o...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-macro-output/td-p/367344

[OTrieger]

@Alteryxuserhere 
As per the picture each product type comes form a different file, therefore you will not necessarily need a batch macro here. Parallel Block Until Done will be enough as it will synchronize the data flow, so if you will create flags you will be able to tell the data where to flow with a simple filter tool.

If all data comes from 1 file, then yes, I totally agree with @Qiu that the way to go about it, using a batch macro.