Icon

Split tables into separate ports based on row partitioning

Demonstration of Create Partition Column component to split a table up into n partitions, and then chain the Regex Multi Row Splitter to output each "partition" on a separate port.

This is much quicker and easier than using a series of Row Splitters since each Regex Multi Row Splitter can output 10 results and then on the remaining 11th port can output the remainder to be picked up by the next Regex Multi Row Splitter in turn.

Each Multi Row splitter is configured with the partition number for each port.

@takbb Brian Bates 28 June 2024

generate 200 rowstables 1-10tables 11-20tables 21-30tables 31-40allocate 40 partitions in chunks of rowsData Generator Regex MultiRow Splitter Regex MultiRow Splitter Regex MultiRow Splitter Regex MultiRow Splitter Create PartitionColumn Partition RowSplitter Partition RowSplitter Partition RowSplitter Partition RowSplitter generate 200 rowstables 1-10tables 11-20tables 21-30tables 31-40allocate 40 partitions in chunks of rowsData Generator Regex MultiRow Splitter Regex MultiRow Splitter Regex MultiRow Splitter Regex MultiRow Splitter Create PartitionColumn Partition RowSplitter Partition RowSplitter Partition RowSplitter Partition RowSplitter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: BATEB031
Created at: 2024-06-28
On NodePit since: 2024-06-29
Last update: 2025-02-18
Created with KNIME version: v5.2.5

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!