Icon

Split rows in to columns

There has been no description set for this workflow's metadata.

Pattern for "grouping rows" where there is a "groupstart marker" rowWe use the Rule Engine to give the "group startmarker a value of 1, and all other rows 0.A moving aggregation then cumulatively sums themarker values.The effect is that we now have all rows for a give n"group" containing a "group label" Here we collect the rows by the defined "column grouping" into List values. So eachgroup of rows becomes a single row held as a List.Using a column filter to keep ONLY the "List " column, we can then transpose it sothat each of the rows now becomes a column containing a single list item, thatcontains all the original rows for that grouping.An ungroup applied to a List, expands the List back out into individual rows again Sample dataFind the "column group" marker (i.e. the "xyz" row)Find groupingsGroup into Listsper groupMake each "row" a columnTurn listsback into rowsKeep only the"List" columnTidy upTidy up rowids Extract Data Tablefrom Delimited Text Rule Engine Moving Aggregation GroupBy Transpose Ungroup Column Filter Column Rename(Regex) RowID Pattern for "grouping rows" where there is a "groupstart marker" rowWe use the Rule Engine to give the "group startmarker a value of 1, and all other rows 0.A moving aggregation then cumulatively sums themarker values.The effect is that we now have all rows for a give n"group" containing a "group label" Here we collect the rows by the defined "column grouping" into List values. So eachgroup of rows becomes a single row held as a List.Using a column filter to keep ONLY the "List " column, we can then transpose it sothat each of the rows now becomes a column containing a single list item, thatcontains all the original rows for that grouping.An ungroup applied to a List, expands the List back out into individual rows again Sample dataFind the "column group" marker (i.e. the "xyz" row)Find groupingsGroup into Listsper groupMake each "row" a columnTurn listsback into rowsKeep only the"List" columnTidy upTidy up rowids Extract Data Tablefrom Delimited Text Rule Engine Moving Aggregation GroupBy Transpose Ungroup Column Filter Column Rename(Regex) RowID

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: bbate
Created at: 2022-10-29
On NodePit since: 2022-10-30
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!