Row to row comparision in knime

KNIME Analytics Platform
#1

Dear Knime experts and enthusiasts! Need some help.

I was to deduct Price in below row from Above row
i.e.
Date Price Difference(Required result)
15-03-2020 60 00
20-03-2020 55 05
21-03-2020 55 00
22-03-2020 51 04

I want column three result i.e. Difference

#2

Hi,
Welcome to the KNIME Forum! Have a look at the Lag Column node. In combination with Math Formula this should be exactly what you need.
Kind regards
Alexander

4 Likes
#3

Thanks you so much for quick reply, this is actually what I was looking for.

3 Likes
#4

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