Hello I have a table in excel where I have a datetime column with the registration of a single event and a column that tells me the type of event that can be “started” or “finished”. I would like to extrapolate from the table the rows in which the event begins and when it ends in order to calculate all the time intervals. For the calculation I can take care of it, but how can I divide the table for those specific datetime?

I solved, separated the values with Row Filter, added the Add Auto Increment node, joined with Concatenate, reordered in increasing order with Sorter, added Add Auto Increment again with a new column, created a third column with the difference of the first two auto increment with Math Function and the difference represents the group to which I apply minimum and maximum

Divide start stop events

KNIME Analytics Platform

mlauber71 August 23, 2022, 12:33pm 2

@pollyste welcome to the KNIME forum. You could try and identify and mark the blocks with numbers and then use a Group By node to identify the Minimum and Maximum.