Lag Column with Negative value?

Seems like this high-demand request for a new Lag Node is still not implemented. But luckily the solution by @ipazin with the Moving Aggregation puts me out of misery. Thank you!

1 Like

I am in team “moving aggregation” however the simple logic from @HansS by changing the sort order, do a normal lag and sort again is also nice (primarily because I myself only thought about moving aggregation from the beginning)
I think what most of us like about KNIME is the flexibility to solve a problem.
br

2 Likes