I am new to Knime and studying as much as possible. Can someone tell me an easy trick to manipulate some data?
I am trying to do statistical analysis on the gaps in a time series. The data looks like Col1, Col 2…
My approach was to 1) add the values together into one new Column, and then 2) Subtract each row from the one before it.
I tried some of the Column nodes such as Filter and Combine, or Join, and Group by Row…but I can’t find the right answer.
The goal is to end up with one column of data that is a time value of the gap of time between Row n and Row n+1. But time needs to be in one column because the gaps continue throughout the new day at midnight.
Has anyone done this before?
Thanks in Advance,