Icon

case - takbb

Step 3 Step 4 Remove all "Emp Hours by xxxxx" values except for the final one (i.e. the subtotal) in each series :-) Node 3Node 4Node 6The 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 41Node 43Node 44Node 45Node 46Node 48Node 49Node 50If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastNode 59Time Worked I have also trouble with Date&Time Difference (TIme Worked Node) I could not convert it to number like 3H 15M => 3.15Node 63Daily Worked TimeNode 69Node 70group by monthNode 72Node 77group by weekgroup by dayJoin monthsJoin weeksJoin DaysEmp Hours by MonthEmp Hours by WeekEmp Hours by Dayclear all but last day value by employee by employee day groupingSorter 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 String Manipulation Table Manipulator Excel Writer ConstantValue Column Concatenate Date&TimeDifference Rule-basedRow Splitter Moving Aggregation Rule-basedRow Splitter Table Manipulator Date&TimeDifference Java Snippet Duration to Number Sorter Extract Date&TimeFields GroupBy Moving Aggregation Excel Reader GroupBy GroupBy Joiner Joiner Joiner Column Rename Column Rename Column Rename Rule Engine Step 3 Step 4 Remove all "Emp Hours by xxxxx" values except for the final one (i.e. the subtotal) in each series :-) Node 3Node 4Node 6The 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 41Node 43Node 44Node 45Node 46Node 48Node 49Node 50If they were differentthen set a 0 valueConcatenateresultsBreakTime_Compute Time differencebetween End & Start timesWindow Type : ForwardWindow Length: 2Aggregate: LastNode 59Time Worked I have also trouble with Date&Time Difference (TIme Worked Node) I could not convert it to number like 3H 15M => 3.15Node 63Daily Worked TimeNode 69Node 70group by monthNode 72Node 77group by weekgroup by dayJoin monthsJoin weeksJoin DaysEmp Hours by MonthEmp Hours by WeekEmp Hours by Dayclear all but last day value by employee by employee day groupingSorter 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 String Manipulation Table Manipulator Excel Writer ConstantValue Column Concatenate Date&TimeDifference Rule-basedRow Splitter Moving Aggregation Rule-basedRow Splitter Table Manipulator Date&TimeDifference Java Snippet Duration to Number Sorter Extract Date&TimeFields GroupBy Moving Aggregation Excel Reader GroupBy GroupBy Joiner Joiner Joiner Column Rename Column Rename Column Rename 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-24
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!