Cumulative sum of consequent numbers in each group

KNIME Analytics Platform
1

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.

2

I found it:

3

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 :wink: :

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

20200620 Pikairos Cumulative sum of consequent numbers in each group
20200620 Pikairos Cumulative sum of consequent numbers in each group1560×528 130 KB

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

All the best

Ael

4

Thanks @aworker. Very nice solution.

Best regards.

5

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

All the best,

Ael