Cumulative sum of consequent numbers in each group

[statman]

Hello,

I have the below data:

KNIME_project5.knwf (4.6 KB)

I want to reach “result” column which depends on x,y and z columns. “result” column is constructed like that:

First,

• x is the grouping variable
• y is the sorting variable(ascending)
• z is summing column

Then,
So for each goup(x), z is cumulative sum according to ascending y.

How can I do this using Knime.

I will be very glad for any help. Thanks a lot.

[statman]

I found it:

Cumulative sum with a condition

This is it, thanks to both of you @armingrudd @mlauber71! Far more complex than I thought it would be, comparing it to my simple SUMIF function in Excel.

[aworker]

Hi @statman

Please find below a generic alternative solution that doesn’t need loops to provide the same results, although it is mathematically more involved to understand :

20200620 Pikairos Cumulative sum of consequent numbers in each group.knwf (43.5 KB)

The workflow is commented to make it easier to understand. Hope this is of help

All the best

Ael

[statman]

Thanks @aworker. Very nice solution.

Best regards.

[aworker]

Thanks @statman for you kind words and for validating the solution

All the best,

Ael