Cumulative Sum for Grouping

Calculates the cumulative sum of a given value column, with the group defined by the grouping column.

Note that this component does not perform any sorting of the data and will treat every change of group name as a new group. If your data is not already grouped into contiguous blocks of rows representing each group, you must sort your data prior to using this component.


@takbb 07 October 2022

Options

Grouping Column
Select the column by which data is to be grouped
Amount Column
Select the column containing the amounts to be cumulatively summed
Cumulative total output column name
Enter a new column name to contain the cumulative total

Input Ports

Icon
Table containing the data for which a cumulative aggregation (sum) is required

Output Ports

Icon
Table with additional column containing the calculated cumulative data

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2022-10-09
Last update: 2024-04-28
Created with KNIME version: v4.6.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!