Icon

Operating Hours 2

Execute this node to find spreadsheetDay of Week Numbersincluding bank holidaysand other special daysGet Start Day NumberAdd additional daysTotal Day Count (including start andend days)convertedto IntGet sequentialrow counterto enable rankingof rows by machineDefine operatingday numberfor each day ofoperation foreach machineGet infofor eachoperating dayfor each machineDetermine costable start time foreach dayof operationDetermine costable end time foreach dayof operationChargeableHours ofOperationby machineApply totalsto original datasetSequence rowsby machineMachine Scheduleof works(spreadsheet)Get 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 machineStrip time from datesSupply date fields to find diffin days betweenTHIS SHOULD BE EMPTYIF IT ISN'T - EDIT THE "DAY TRANSLATION"TABLEOpen File or Folder Table Creator Cell Replacer One Row to Many Math Formula Rank Math Formula Joiner Rule Engine Rule Engine Math Formula Joiner Rank Excel Reader 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 Unpivoting Joiner 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 Date&Time to String String to Date&Time Column Filter Execute this node to find spreadsheetDay of Week Numbersincluding bank holidaysand other special daysGet Start Day NumberAdd additional daysTotal Day Count (including start andend days)convertedto IntGet sequentialrow counterto enable rankingof rows by machineDefine operatingday numberfor each day ofoperation foreach machineGet infofor eachoperating dayfor each machineDetermine costable start time foreach dayof operationDetermine costable end time foreach dayof operationChargeableHours ofOperationby machineApply totalsto original datasetSequence rowsby machineMachine Scheduleof works(spreadsheet)Get 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 machineStrip time from datesSupply date fields to find diffin days betweenTHIS SHOULD BE EMPTYIF IT ISN'T - EDIT THE "DAY TRANSLATION"TABLEOpen File or Folder Table Creator Cell Replacer One Row to Many Math Formula Rank Math Formula Joiner Rule Engine Rule Engine Math Formula Joiner Rank Excel Reader 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 Unpivoting Joiner 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 Date&Time to String String to Date&Time 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: brian
Created at: 2021-07-25
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.0

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

Try NodePit Runner!