Icon

merge tabulated columns and aggregate

Demo workflow in response to forum query

https://forum.knime.com/t/merge-multiple-columns-in-one-column/68859

Cols for bracket1Cols for bracket2Cols for bracket3pull rows togetherAmount BracketAmount BracketAmount Bracketdemo dataAggregate valuesAggregate valuesAggregate valuestidy upsome kind oforderingzeroes wheremissingColumn Filter Column Filter Column Filter Concatenate Column Rename Column Rename Column Rename Excel Reader GroupBy GroupBy GroupBy RowID Sorter Missing Value Cols for bracket1Cols for bracket2Cols for bracket3pull rows togetherAmount BracketAmount BracketAmount Bracketdemo dataAggregate valuesAggregate valuesAggregate valuestidy upsome kind oforderingzeroes wheremissingColumn Filter Column Filter Column Filter Concatenate Column Rename Column Rename Column Rename Excel Reader GroupBy GroupBy GroupBy RowID Sorter Missing Value

Nodes

Extensions

Links