How to update the values on a column as the sum of the value from the column and the column before?

Hi everyone,

I want to update the values in a column as the sum of the said values + the value from the column before. Example:

1 2 3 4
0 1 2 3
0 0 1 2

I am trying to turn the table above to the one in below.

1 3 6 10
0 1 3 6
0 0 1 3

Any help is appreciated :slight_smile:

1 Like

Hi Cem,
Welcome to the KNIME world!

Please find the attached files for your convenience.
As requested, I’ve utilized the Table Transposer and Moving Aggregation nodes.

Best regards,
Alpay Zeybek

CemSentay.knwf (11.4 KB)
CEMSENTAY.xlsx (13.3 KB)

2 Likes

Hi Alpay,

Thank you very much, this solved my problem.

Best Regards,
Cem Şentay

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.