Icon

Split and stack table

Workflow showing a number of ways that a table can be split into subsets of columns and then stacked

This shows how to do this by Table Cropper and Concatenate, but also using UnPivot / Pivot and additionally shows ways to rename the columns.

It also, in some cases, utilises components to address some of the complexity.

@takbb componentcols 1 - 9cols 10 to 18cols 19 to 27stack tablesrename colsget columnlookup tablefrom "top table"rename colscols 1 - 9cols 10 to 18cols 19 to 27@takbb componentstack tablesNode 23make cols into rowsmake rows into lists@takbb componentcomponent to do the above for yourename the"column names"as requiredNode 31Node 32sort into stack table ordermake listsinto rowsmark rowsin threes. 3 = number of stacked tables)tidy uptidy uptidy uptidy upmake column namesmake rows into listsmake listsinto rowsget column namesColumn Name lookup tableapply column namessort into stack table ordermark rowsin threes. 3 = number of stacked tables)tidy uptidy upReplace TableColumn Names Table Cropper Table Cropper Table Cropper Concatenate Column Renamer(Dictionary) Column NameExtractor Column NameExtractor Column NameExtractor Table Transposer Column Renamer(Dictionary) Table Cropper Table Cropper Table Cropper Replace TableColumn Names Concatenate Table Creator Unpivot Pivot Stack TableColumns as Rows Rule Engine Table Creator Table Creator Sorter Ungroup Math Formula Column Filter RowID RowID Column Filter String Manipulation Pivot Ungroup Column NameExtractor Table Transposer Column Renamer(Dictionary) Sorter Math Formula RowID Column Filter @takbb componentcols 1 - 9cols 10 to 18cols 19 to 27stack tablesrename colsget columnlookup tablefrom "top table"rename colscols 1 - 9cols 10 to 18cols 19 to 27@takbb componentstack tablesNode 23make cols into rowsmake rows into lists@takbb componentcomponent to do the above for yourename the"column names"as requiredNode 31Node 32sort into stack table ordermake listsinto rowsmark rowsin threes. 3 = number of stacked tables)tidy uptidy uptidy uptidy upmake column namesmake rows into listsmake listsinto rowsget column namesColumn Name lookup tableapply column namessort into stack table ordermark rowsin threes. 3 = number of stacked tables)tidy uptidy upReplace TableColumn Names Table Cropper Table Cropper Table Cropper Concatenate Column Renamer(Dictionary) Column NameExtractor Column NameExtractor Column NameExtractor Table Transposer Column Renamer(Dictionary) Table Cropper Table Cropper Table Cropper Replace TableColumn Names Concatenate Table Creator Unpivot Pivot Stack TableColumns as Rows Rule Engine Table Creator Table Creator Sorter Ungroup Math Formula Column Filter RowID RowID Column Filter String Manipulation Pivot Ungroup Column NameExtractor Table Transposer Column Renamer(Dictionary) Sorter Math Formula RowID Column Filter

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-04-15
On NodePit since: 2024-04-16
Last update: 2024-05-01
Created with KNIME version: v5.2.2

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

Try NodePit Runner!