Icon

case

Step 3 Step 4 Node 3Node 4Node 6The simplestway to solve this:Filter out useless columnsNode 22Node 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 dayNode 80union of two tablesunion of the rest data Sorter Row Filter Column Filter Java Snippet Lag Column Rule Engine Column Filter GroupBy 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 Concatenate Concatenate Step 3 Step 4 Node 3Node 4Node 6The simplestway to solve this:Filter out useless columnsNode 22Node 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 dayNode 80union of two tablesunion of the rest data Sorter Row Filter Column Filter Java Snippet Lag Column Rule Engine Column Filter GroupBy 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 Concatenate 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-24
On NodePit since: 2022-02-06
Last update: 2024-04-30
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!