Calculation row by row (e.g. growth)

Hi guys,

need your help again. :slight_smile:

I want to calculate the growth year by year.
In theory, of course, I know how it works mathematically.
Therefore I would like to know how best to put this into practice in KNIME?
To calculate something row by row.
I added an example to illustrate.

Thanks in advance!

Andre

Search the lag column node. With the node you can “duplicate” the products column but from the next row and then you can apply your calculation. due to how the lag column works I think you will need to sort in descending order. But I leave that trial& error up to you.

2 Likes

Hi @kienerj,

works! Great! Big thanks!

BR

Andre

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