Compare/Subtract Data with same characteristic from different dates

[luise295]

Hello Knime Community, I’m dealing with the following issue:

That’s the data I have, what I need to do is subtract the data from the column “Valor Mercado” having the date as a reference and create a new column with the result.

what I need to do is the equivalent to the following image from excel:

Hope I was clear enough.

Best Regards.

[Kathrin]

Hi @luise295 and welcome to the KNIME Community Forum

Please find here a small example workflow to solve this step by using a Lag Column and a Math Formula node: Substract values of two consecutive rows – KNIME Hub

Cheers
Kathrin