Icon

Data Wrangling _​ Working Out Overlapping Downtime

Data Wrangling _ Working Out Overlapping Downtime

Data Wrangling _ Working Out Overlapping Downtime

https://forum.knime.com/t/based-on-system-is-there-overlapping-downtime/48226

DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.

cross all downtimesLoop by System intra-system overlap searchremove 1.- self-crossing2.- select chronologyinclude downtime related columnsset starting overlap timewhen there is an overlapset ending overlap timewhen there is an overlapchallenge dataUnique SystemLoop by System inter-system overlap searchUpper: System in LoopLower: Other Systeminclude downtime related columnscross all downtimesset ending overlap timewhen there is an overlapremove 1.- self-crossing2.- select chronologyset starting overlap timewhen there is an overlapCollect intra-systemOverlapsCollect inter-system OverlapsCross Joiner Group Loop Start Rule-basedRow Filter Column Filter Rule Engine Rule Engine OverlappingDowntime GroupBy Table Row ToVariable Loop Start Rule-basedRow Splitter Column Filter Cross Joiner Rule Engine Rule-basedRow Filter Rule Engine Loop End Loop End cross all downtimesLoop by System intra-system overlap searchremove 1.- self-crossing2.- select chronologyinclude downtime related columnsset starting overlap timewhen there is an overlapset ending overlap timewhen there is an overlapchallenge dataUnique SystemLoop by System inter-system overlap searchUpper: System in LoopLower: Other Systeminclude downtime related columnscross all downtimesset ending overlap timewhen there is an overlapremove 1.- self-crossing2.- select chronologyset starting overlap timewhen there is an overlapCollect intra-systemOverlapsCollect inter-system OverlapsCross Joiner Group Loop Start Rule-basedRow Filter Column Filter Rule Engine Rule Engine OverlappingDowntime GroupBy Table Row ToVariable Loop Start Rule-basedRow Splitter Column Filter Cross Joiner Rule Engine Rule-basedRow Filter Rule Engine Loop End Loop End

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: RE90273
Created at: 2022-10-20
On NodePit since: 2022-11-12
Last update: 2024-11-21
Created with KNIME version: v4.5.2

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

Try NodePit Runner!