Icon

Removing Date ranges 1

There has been no description set for this workflow's metadata.

sample datanegatives go tobottomcollector portCreate all rowsbetween start and end dateloop rowssequentiallyName and Unitspositives topnegatives bottomremove negativesby joining andexcluding matchescalc differencein dates for rowto previous rowLag Namefind where each contiguious group ofdates starts(name is different to previous rowordate difference between rowsis not 1)Mark groups with a 1ensure rowsare in name and dateorderdetermine start, end and unitsfor each name and groupingassign uniquesequence numberfor each groupingby cumulativelysumming the 1s createdin Rule Enginerename columnsand tidy upExcel Reader Row Splitter Create Date&TimeRange Table Row ToVariable Loop Start Variable toTable Column Loop End Joiner Date&TimeDifference Lag Column Rule Engine Sorter GroupBy Moving Aggregation Table Manipulator sample datanegatives go tobottomcollector portCreate all rowsbetween start and end dateloop rowssequentiallyName and Unitspositives topnegatives bottomremove negativesby joining andexcluding matchescalc differencein dates for rowto previous rowLag Namefind where each contiguious group ofdates starts(name is different to previous rowordate difference between rowsis not 1)Mark groups with a 1ensure rowsare in name and dateorderdetermine start, end and unitsfor each name and groupingassign uniquesequence numberfor each groupingby cumulativelysumming the 1s createdin Rule Enginerename columnsand tidy upExcel Reader Row Splitter Create Date&TimeRange Table Row ToVariable Loop Start Variable toTable Column Loop End Joiner Date&TimeDifference Lag Column Rule Engine Sorter GroupBy Moving Aggregation Table Manipulator

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: 2024-05-28
On NodePit since: 2024-05-29
Last update: 2024-09-16
Created with KNIME version: v4.7.8

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

Try NodePit Runner!