datetimediff in column expression
Hello,
I’m trying to convert the following code from Alteryx to Knime:
if [Row-1:Tail Number]=[Tail Number] AND [Origin IATA]=[Row-1:Destination IATA] then datetimediff([Gate Skd Departure Date-Time (UTC)],[Row-1:Gate Actual Arrival Date-Time (UTC)],“minutes”)else null() endif
Using, column expression, I created the following code snippet:
if(column(“Tail Number”,-1) == column(“Tail Number”) && column(“Origin IATA”) == column(“Destination IATA”, -1)){ 1 } else { null }
Unfortunately, I cannot seem to figure out how to get the datetimediff argument to work. Any ideas?
Thank you!