Compare/Subtract Data with same characteristic from different dates

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:

Captura de Pantalla 2022-06-07 a la(s) 8.56.53 p.m.

Hope I was clear enough.

Best Regards.

Hi @luise295 and welcome to the KNIME Community Forum :slight_smile:

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


1 Like

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