Divide start stop events

[pollyste]

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?

[mlauber71]

@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.

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row To Variable Loop Start – KNIME Hub or Group Loop Start – KNIME Hub to do something with the blocks (export them delete lines with missing…

[pollyste]

Yes I know,
but it’s possible with a knime nodes?
I used window function in mysql to obtain it.
Here how i could make?

[mlauber71]

@pollyste the examples use KNIME nodes. Maybe you give them a try.

[ScottF]

It would be helpful if for you to post some example data, if you are able, along with what your desired output would look like.

[pollyste]

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