Hi @patrik26 ,
A similar need arose some time ago, and whilst no node exists for this, I wrote a couple of components that do something similar to what you are asking, I think. They allow you to split a table automatically based on either different single values in a given column, or by using a regex pattern (or just the specific text) to define the rows that are to match each sub-table.
Limitations of components are that you cannot create a dynamic number of outputs, so I settled for having 11 outputs (10 sub-tables and the 11th being any “carry over” rows that didn’t make it into the first 10. Then if you require more than 10 sub-tables, you can simply chain the final output into another copy of the component, for further partitioning.
For a demonstration workflow, see here:
In this workflow, it also makes use of a further component that can create a partitioning column that then allows the table to be divided either a fixed number of partitions, or a fixed number of rows per partition.
Sorry I’m late to the party with this, but maybe it will be of future use!
further background on the above: