Berechnung einer neuen Spalte mit Werten aus vorheriger Zeile #THK-DSFB-2023

[mlauber71]

@palterau welcome to the KNIME forum. The Column Expressions – KNIME Community Hub does have a multi-row access where you can reference values from other lines. You might as well add a condition when these lines should be invoked.

datetimediff in column expression

@Neico I think the Column Expression node does not have a direct DateDiff function. What I did was I changed the condition and gave out the LAG-DateTime when the condition was met and then used a KNIME node. [image] Another option would be to use a Group Loop to have the Tail Number in one group. Also note you will have to activate the multi-row access. [image]

An alternative could be to join the data via ID and the month/year.