Icon

20210506 Pikairos Four rows aggregation

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

Your DataThe trick to achievea grouping ofonly 4 consecutive rows:Generate an Indexto group by 4 rowsfloor( $$ROWINDEX$$ / 4)Group bythis new index andaggregate to calculatethe sumJoin the rowsto their sumsThis is needed tokeep just the first sumof a groupedset or 4 rowsSet to blanksum result thatare not the firstof the 4 grouped rowsClean upthe table and leaveonly required columnsThe finalrequired resultTable Creator Math Formula GroupBy Joiner Moving Aggregation Rule Engine Column Filter InteractiveTable (local) Your Data The trick to achievea grouping ofonly 4 consecutive rows:Generate an Indexto group by 4 rowsfloor( $$ROWINDEX$$ / 4)Group bythis new index andaggregate to calculatethe sumJoin the rowsto their sumsThis is needed tokeep just the first sumof a groupedset or 4 rowsSet to blanksum result thatare not the firstof the 4 grouped rowsClean upthe table and leaveonly required columnsThe finalrequired resultTable Creator Math Formula GroupBy Joiner Moving Aggregation Rule Engine Column Filter 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-05-06
On NodePit since: 2022-02-06
Last update: 2024-05-03
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!