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!