I am looking for the best way to split data streams based on a value within a node.
Say I have
Header
Row
ValueA
/Row
Row
ValueB
/Row
Row
ValueA
/Row
Row
ValueC
/Row
/Header
I want to split that into 3 streams based on a value but still keep all of the parent node information… as so.
Header
Row
ValueA
/Row
Row
ValueA
/Row
/Header
Header
Row
ValueB
/Row
/Header
Header
Row
ValueC
/Row
/Header
What would be the best way to handle this?
Also, this isnt always going to be split into exactly 3. I want it to be dynamic and able to handle as many streams as possible. Hypothetically there could be 500 rows with 100 different values