Icon

JKI_​020

JKI_020
Lag: Groupwise + Multicolumn ensures that start and end are on weekdays--> if start date is on weekend, shifts it to next monday;--> if end date is on weekend, shifts it to previous friday; same (improved logic) Node Golf inputdatadayOfWeekrowIndexrowIndex + 1joinLEFTdaysToShiftdaysToShift(right)shiftend dateshiftstart dateNode 10calcNetwork DayscalcmeancolumnfilterNode 14inputdatacalcNetwork DayscalcMeanNode 18joinLEFTrowIndexinputdatadayOfWeekrowIndex + 1Node 14Node 25calcmeancalcNetwork Dayscolumnfilter Table Creator Extract Date&TimeFields Math Formula Math Formula Joiner Math Formula Math Formula Date&Time Shift Date&Time Shift Date&TimeDifference Math Formula GroupBy Joiner Column Rename Table Creator Java Snippet GroupBy Joiner Joiner Math Formula Table Creator Extract Date&TimeFields Math Formula Column Rename Date&TimeDifference GroupBy Math Formula Joiner Lag: Groupwise + Multicolumn ensures that start and end are on weekdays--> if start date is on weekend, shifts it to next monday;--> if end date is on weekend, shifts it to previous friday; same (improved logic) Node Golf inputdatadayOfWeekrowIndexrowIndex + 1joinLEFTdaysToShiftdaysToShift(right)shiftend dateshiftstart dateNode 10calcNetwork DayscalcmeancolumnfilterNode 14inputdatacalcNetwork DayscalcMeanNode 18joinLEFTrowIndexinputdatadayOfWeekrowIndex + 1Node 14Node 25calcmeancalcNetwork Dayscolumnfilter Table Creator Extract Date&TimeFields Math Formula Math Formula Joiner Math Formula Math Formula Date&Time Shift Date&Time Shift Date&TimeDifference Math Formula GroupBy Joiner Column Rename Table Creator Java Snippet GroupBy Joiner Joiner Math Formula Table Creator Extract Date&TimeFields Math Formula Column Rename Date&TimeDifference GroupBy Math Formula Joiner

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: JohannesHolzschuh
Created at: 2022-06-13
On NodePit since: 2022-06-14
Last update: 2024-04-28
Created with KNIME version: v4.5.2
Tags: JustknimeitJustknimeit-20Java SnippetNode Golf

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

Try NodePit Runner!