Icon

kn_​forum_​74434_​datetimediff_​column_​expression

date differences with LAG function from Column expressions

date differences with LAG function from Column expressions

date differences with LAG function from Column expressions Sample data preparations if ( column("Tail Number", -1) === column("Tail Number") && column("Origin IATA") === column("Destination IATA",-1)) { column("Gate Skd Departure Date-Time (UTC)",-1) } else { null} flights.txtNode 3Node 4Node 5Node 6Node 7if conditions match fill"Previous - Gate Skd Departure Date-Time (UTC)"Node 9flights.tableflights.table File Reader Row Filter Column Filter Column AutoType Cast RowID String to Date&Time Column Expressions Date&TimeDifference Table Writer Table Reader date differences with LAG function from Column expressions Sample data preparations if ( column("Tail Number", -1) === column("Tail Number") && column("Origin IATA") === column("Destination IATA",-1)) { column("Gate Skd Departure Date-Time (UTC)",-1) } else { null} flights.txtNode 3Node 4Node 5Node 6Node 7if conditions match fill"Previous - Gate Skd Departure Date-Time (UTC)"Node 9flights.tableflights.table File Reader Row Filter Column Filter Column AutoType Cast RowID String to Date&Time Column Expressions Date&TimeDifference Table Writer Table Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2023-10-23
On NodePit since: 2023-10-24
Last update: 2024-04-27
Created with KNIME version: v4.7.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!