Icon

Find first and last for contiguous groupings and retain timestamp columns

Find First and Last timestamps in contiguous grouping based on multiple columns

Find first and last item in a contiguous group and then retain specific start and end columns

Sample Datacreate a "group key"set a new "key-sum"columnto 1get an ordering based on the "group key"by cumulatively addingthe key-sum within eachgroupget the ordering forthe next rowwhere group-posis 1, this isa "start" rowwhere group-pos (lag)is 1, this is an "end" rowpopulate missing end times based on next available valueremove superflous rowsget required tableExtract Data Tablefrom Delimited Text Column Combiner Math Formula Cumulative Sumfor Grouping Lag Column Rule Engine Rule Engine Missing Value Row Filter Column Filter Sample Datacreate a "group key"set a new "key-sum"columnto 1get an ordering based on the "group key"by cumulatively addingthe key-sum within eachgroupget the ordering forthe next rowwhere group-posis 1, this isa "start" rowwhere group-pos (lag)is 1, this is an "end" rowpopulate missing end times based on next available valueremove superflous rowsget required tableExtract Data Tablefrom Delimited Text Column Combiner Math Formula Cumulative Sumfor Grouping Lag Column Rule Engine Rule Engine Missing Value Row Filter Column Filter

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: BATEB031
Created at: 2023-05-09
On NodePit since: 2023-05-09
Last update: 2024-04-27
Created with KNIME version: v4.7.1

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

Try NodePit Runner!