Cumulative Sum for Non Contiguous Grouping

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

This component is likely to use more memory than the basic Cumulative Sum for Grouping component as it handles non-contiguous groupings. It does not affect row order but keeps a running total for each named group irrespective of whether grouped rows are interleaved.

e.g.

A 10
B 10
B 20
A 20
B 30
C 10
C 20

would result in

A 10 10
B 10 10
B 20 30
A 20 30
B 30 60
C 10 10
C 20 30

@takbb 08 October 2022

Input ports

1. Type: Table
   Table containing the data for which a cumulative aggregation (sum) is required

Output ports

1. Type: Table
   Table with additional column containing the calculated cumulative data