Icon

contingent worker_​beta

Step 3 Step 4 Step 2 Soritng name by ascSorting Trn Start Date by ascFilter:Worked Shift SegmentFiltering out columnsThe simplestway to solve this:Filter out useless columnsSort by Employeeand ApplyDateGet Start and End row for eachEmpDayEmpDayGroupEmpWeekGroupEmpMonthGroupGet Start and End row for each EmpWeekGet Start and End row for each EmpMonthNode 22clear all but last week value by employeeweek groupingclear all but last month value by employee month groupingRemove grouping columnsNode 30Node 33Node 34Node 37Node 38Node 40Node 41Converting into Date typeNode 44Node 46If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastTime WorkedNode 63Daily Worked TimeNode 69Node 88group by monthgroup by weekHours by DayEmp Hours for WeekEmp Hours for MonthEmp Hours for DayAppend Hours for DayAppend Hours for MonthAppend Hours for Weekclear all but last day value by employee by employee day groupingNode 104Get Start and End row for eachEmpDayNode 111Node 112Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 124Node 125Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 137Node 138Node 139Node 140Node 141new column withMonthlyApply date withMonthlyfiltering monthlynew column withDailyfiltering dailyDaily + TotalNode 150weekly+daily+monthlyfiltering weeklynew column withWeeklyApply date withWeeklyNode 155 Sorter Row Filter Column Filter Java Snippet Lag Column Rule Engine Column Filter Sorter First and Lastfor Group Column Combiner Column Combiner Column Combiner First and Lastfor Group First and Lastfor Group GroupBy Rule Engine Rule Engine Column Filter GroupBy Column Filter Excel Writer Rule Engine Lag Column Lag Column Date&TimeDifference String to Date&Time Date&TimeDifference Table Manipulator ConstantValue Column Concatenate Date&TimeDifference Rule-basedRow Splitter Moving Aggregation Date&TimeDifference Java Snippet Duration to Number Sorter Extract Date&TimeFields GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename Joiner Joiner Joiner Rule Engine String Manipulation First and Lastfor Group Rule Engine Rule Engine Round Double GroupBy Sorter Table Manipulator Sorter Data to Report String Manipulation String To Number Round Double String Manipulation GroupBy Table Manipulator Concatenate Sorter String to Date&Time Sorter Sorter CSV Reader Add Empty Rows String Manipulation Rule Engine Rule Engine Rule Engine Rule Engine Row Filter Rule Engine Row Filter String Manipulation Concatenate Concatenate Row Filter Rule Engine Rule Engine Concatenate Step 3 Step 4 Step 2 Soritng name by ascSorting Trn Start Date by ascFilter:Worked Shift SegmentFiltering out columnsThe simplestway to solve this:Filter out useless columnsSort by Employeeand ApplyDateGet Start and End row for eachEmpDayEmpDayGroupEmpWeekGroupEmpMonthGroupGet Start and End row for each EmpWeekGet Start and End row for each EmpMonthNode 22clear all but last week value by employeeweek groupingclear all but last month value by employee month groupingRemove grouping columnsNode 30Node 33Node 34Node 37Node 38Node 40Node 41Converting into Date typeNode 44Node 46If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastTime WorkedNode 63Daily Worked TimeNode 69Node 88group by monthgroup by weekHours by DayEmp Hours for WeekEmp Hours for MonthEmp Hours for DayAppend Hours for DayAppend Hours for MonthAppend Hours for Weekclear all but last day value by employee by employee day groupingNode 104Get Start and End row for eachEmpDayNode 111Node 112Node 116Node 117Node 118Node 119Node 120Node 121Node 122Node 123Node 124Node 125Node 129Node 130Node 131Node 132Node 133Node 134Node 135Node 137Node 138Node 139Node 140Node 141new column withMonthlyApply date withMonthlyfiltering monthlynew column withDailyfiltering dailyDaily + TotalNode 150weekly+daily+monthlyfiltering weeklynew column withWeeklyApply date withWeeklyNode 155 Sorter Row Filter Column Filter Java Snippet Lag Column Rule Engine Column Filter Sorter First and Lastfor Group Column Combiner Column Combiner Column Combiner First and Lastfor Group First and Lastfor Group GroupBy Rule Engine Rule Engine Column Filter GroupBy Column Filter Excel Writer Rule Engine Lag Column Lag Column Date&TimeDifference String to Date&Time Date&TimeDifference Table Manipulator ConstantValue Column Concatenate Date&TimeDifference Rule-basedRow Splitter Moving Aggregation Date&TimeDifference Java Snippet Duration to Number Sorter Extract Date&TimeFields GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename Joiner Joiner Joiner Rule Engine String Manipulation First and Lastfor Group Rule Engine Rule Engine Round Double GroupBy Sorter Table Manipulator Sorter Data to Report String Manipulation String To Number Round Double String Manipulation GroupBy Table Manipulator Concatenate Sorter String to Date&Time Sorter Sorter CSV Reader Add Empty Rows String Manipulation Rule Engine Rule Engine Rule Engine Rule Engine Row Filter Rule Engine Row Filter String Manipulation Concatenate Concatenate Row Filter Rule Engine Rule Engine Concatenate

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: Karlygash_Mukhitova
Created at: 2021-06-22
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!