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

[CemSentay]

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

[alpayzeybek]

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)

[CemSentay]

Hi Alpay,

Thank you very much, this solved my problem.

Best Regards,
Cem Şentay