Icon

Operating hours - adj

Calculating Operating hours - as per Band for operating hours Get infofor eachoperating dayfor each machineDetermine costable start time foreach dayof operationDetermine costable end time foreach dayof operationChargeableHours ofOperationby machineApply totalsto original datasetSequence rowsby machineGet Day of Weekmake nameswork with rest of flowReduce columnsPublic HolidaysEDIT AS REQUIREDDayCode must match "Operating Hours"table codesGet Date for this dayWork dateto yyyy-MM-ddformatMark HolidaysWork DateTotal count of daysGet Offset foreach day(starting at zero)Get Start and End row for each group(component)Unique GroupLabelGet Start/End TimeConvert backto LocalTimeReplace DayNumber forPublic HolidaysDay TranslationEDIT TO SUPPORTDAY DESCRIPTIONSDetermine operating days for each machineOperating Hours by MachineUnpivot to generate tables for all machinesGet Day NumbersDayNameOperationalDayReplace missing with "N" toshow non-operation daysClear Start timewhere not operational dayClear End timewhere not operational dayStart and End time as TIMEOpStartTimeOpEndTimeNeed to convert operatingtimes to stringas we need to deal withend times as "24:00" and not "00:00"in order to calculate correctdifferencesOpEndTime to "24:00"from "00:00"EndTime to "24:00"from "00:00"Calc Costable Minutesfrom string form of timesto allow for 24:00 instead of00:00Group by machineDay of Week Numbersincluding bank holidaysand other special daysAdd additional daysSupply date fields to find diffin days betweenGet Start Day NumberTotal Day Count (including start andend days)convertedto IntStrip time from datesGet sequentialrow counterto enable rankingof rows by machineTHIS SHOULD BE EMPTYIF IT ISN'T - EDIT THE "DAY TRANSLATION"TABLEDefine operatingday numberfor each day ofoperation foreach machineRemoving repeats ofOperating hours for Machine/IDUnique GroupLabelNode 88 Joiner (Labs) Rule Engine Rule Engine Math Formula Joiner (Labs) Rank Date&Time to String Column Rename Column Filter Table Creator Date&Time Shift Date&Time to String Cell Replacer Column Rename Date&TimeDifference Math Formula First and Lastfor Group String Manipulation Date&Time to String String to Date&Time Rule Engine Table Creator Joiner (Labs) Unpivoting Joiner (Labs) Column Rename Missing Value Rule Engine Rule Engine String to Date&Time Column Rename Date&Time to String Rule Engine Rule Engine Column Expressions GroupBy Table Creator One Row to Many String to Date&Time Cell Replacer Math Formula Date&Time to String Rank Column Filter Math Formula DuplicateRow Filter String Manipulation Excel Reader Calculating Operating hours - as per Band for operating hours Get infofor eachoperating dayfor each machineDetermine costable start time foreach dayof operationDetermine costable end time foreach dayof operationChargeableHours ofOperationby machineApply totalsto original datasetSequence rowsby machineGet Day of Weekmake nameswork with rest of flowReduce columnsPublic HolidaysEDIT AS REQUIREDDayCode must match "Operating Hours"table codesGet Date for this dayWork dateto yyyy-MM-ddformatMark HolidaysWork DateTotal count of daysGet Offset foreach day(starting at zero)Get Start and End row for each group(component)Unique GroupLabelGet Start/End TimeConvert backto LocalTimeReplace DayNumber forPublic HolidaysDay TranslationEDIT TO SUPPORTDAY DESCRIPTIONSDetermine operating days for each machineOperating Hours by MachineUnpivot to generate tables for all machinesGet Day NumbersDayNameOperationalDayReplace missing with "N" toshow non-operation daysClear Start timewhere not operational dayClear End timewhere not operational dayStart and End time as TIMEOpStartTimeOpEndTimeNeed to convert operatingtimes to stringas we need to deal withend times as "24:00" and not "00:00"in order to calculate correctdifferencesOpEndTime to "24:00"from "00:00"EndTime to "24:00"from "00:00"Calc Costable Minutesfrom string form of timesto allow for 24:00 instead of00:00Group by machineDay of Week Numbersincluding bank holidaysand other special daysAdd additional daysSupply date fields to find diffin days betweenGet Start Day NumberTotal Day Count (including start andend days)convertedto IntStrip time from datesGet sequentialrow counterto enable rankingof rows by machineTHIS SHOULD BE EMPTYIF IT ISN'T - EDIT THE "DAY TRANSLATION"TABLEDefine operatingday numberfor each day ofoperation foreach machineRemoving repeats ofOperating hours for Machine/IDUnique GroupLabelNode 88Joiner (Labs) Rule Engine Rule Engine Math Formula Joiner (Labs) Rank Date&Time to String Column Rename Column Filter Table Creator Date&Time Shift Date&Time to String Cell Replacer Column Rename Date&TimeDifference Math Formula First and Lastfor Group String Manipulation Date&Time to String String to Date&Time Rule Engine Table Creator Joiner (Labs) Unpivoting Joiner (Labs) Column Rename Missing Value Rule Engine Rule Engine String to Date&Time Column Rename Date&Time to String Rule Engine Rule Engine Column Expressions GroupBy Table Creator One Row to Many String to Date&Time Cell Replacer Math Formula Date&Time to String Rank Column Filter Math Formula DuplicateRow Filter String Manipulation Excel Reader

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: z001kvph
Created at: 2021-06-04
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.3

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

Try NodePit Runner!