Icon

20210426 Pikairos How to sum up columns of each same data set

20210426 PIKAIROS How to sum up columns of each same data set

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

Table DataAd columnwith row IndexSplit rowsbased onempty ModelConcatenaterows usingunion of columnsRemoveModel Columnto artificiallycreate empty valuesSort based onRowIndexColumnReplaceMissing Valueswith previousvalue in ColumnGroup byModel &aggregateusing sum tocompute totalsAdd Totalto Modelin summed rowsConcatenateoriginal rowswith computedtotal rowsSort based onInitialRow IndexReplaceMissing Valueswith blanksFilter outcolumns notanymoreneededRestoreModel Columnas initially usingthis Lag node ..... and thisRule Enginenode asa trickThe Tablewith Totals per ModelExcel Reader (XLS) Math Formula Row Splitter Concatenate Column Splitter Sorter Missing Value GroupBy String Manipulation Concatenate Sorter Missing Value Column Filter Lag Column Rule Engine InteractiveTable (local) Table DataAd columnwith row IndexSplit rowsbased onempty ModelConcatenaterows usingunion of columnsRemoveModel Columnto artificiallycreate empty valuesSort based onRowIndexColumnReplaceMissing Valueswith previousvalue in ColumnGroup byModel &aggregateusing sum tocompute totalsAdd Totalto Modelin summed rowsConcatenateoriginal rowswith computedtotal rowsSort based onInitialRow IndexReplaceMissing Valueswith blanksFilter outcolumns notanymoreneededRestoreModel Columnas initially usingthis Lag node ..... and thisRule Enginenode asa trickThe Tablewith Totals per ModelExcel Reader (XLS) Math Formula Row Splitter Concatenate Column Splitter Sorter Missing Value GroupBy String Manipulation Concatenate Sorter Missing Value Column Filter Lag Column Rule Engine InteractiveTable (local)

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: Molina
Created at: 2021-04-26
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.2.4

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

Try NodePit Runner!