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

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

Nodes

• Column Rename2 ×
• Column Selection Configuration2 ×
• Column Filter1 ×
• Component Input1 ×
• Component Output1 ×
• Java Snippet1 ×
• Merge Variables1 ×
• String Configuration1 ×
• String Manipulation1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available