Comparing row to row

Hello everyone,

I'm currently using knime mainly on xls files, and to try and set conditions I use mainly the Rule engine node or the math formula depending on my type of data.

is there a way to compare rows : [row +1}] - [row];

I had tried using the lag column then comparing the 2 columns but this methos had its limitations.

 

Thanks in advance guys.

 

Regards,

 

Ayoub

Hi,

did you check out the Moving Aggregation node?

It allows you to aggregate a sliding window on your data. E.g. a range of a backward window of two equals the difference between the value and the previous value.

Best, Iris

1 Like