I have just started using KNIME and wanted help on this item.
I am trying to put in a check to get the difference between the two values in the Net Weight Column to make they are the same. I tried using the Column Expression node but was not able to come up with the answer.
There a multiple ways to do the calculation, see this simple wf difference_between_2_values.knwf (28.7 KB). I think the best solutions depends on how you want to use this calculation in your workflow / analysis.
You could use Moving Aggregation, calculate the Variance (2 step window) and then check wether it is 0
(@HansS Solution is probably the way to go. Just trying to be creative here)
br