Icon

emp_​data_​2

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 37Node 38Node 40Node 41Converting into Date typeNode 44Node 45Node 46If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastTime WorkedNode 63Daily Worked TimeNode 69Node 70Node 71Node 72Node 88group by monthNode 92group 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 102Get Start and End row for Employee"Last" of groupaggregationsto "missing""Last" of groupaggregationsto "missing" 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 Rule Engine Lag Column Lag Column Date&TimeDifference String to Date&Time Date&TimeDifference 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 Moving Aggregation Extract Date&TimeFields GroupBy GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename Joiner Joiner Joiner Rule Engine CSV Reader First and Lastfor Group Rule Engine Rule Engine 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 37Node 38Node 40Node 41Converting into Date typeNode 44Node 45Node 46If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastTime WorkedNode 63Daily Worked TimeNode 69Node 70Node 71Node 72Node 88group by monthNode 92group 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 102Get Start and End row for Employee"Last" of groupaggregationsto "missing""Last" of groupaggregationsto "missing" 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 Rule Engine Lag Column Lag Column Date&TimeDifference String to Date&Time Date&TimeDifference 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 Moving Aggregation Extract Date&TimeFields GroupBy GroupBy GroupBy GroupBy Column Rename Column Rename Column Rename Joiner Joiner Joiner Rule Engine CSV Reader First and Lastfor Group Rule Engine Rule Engine

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!