Icon

Period_​aggregations

Input sum.xlsx73 rowsTransaction Apply DateGet Year, Month Numberand Week Number in YearHours by DayHours by Year-WeekHours by Year-MonthCombine Year-Monthinto a "key"Combine Year:Weekinto a "key"Append Hours for MonthAppend Hours for WeekAppend Hours for DayOutput still has 73 rows :-)Emp Hours for MonthEmp Hours for WeekEmp Hours for WeekExcel Reader String to Date&Time Extract Date&TimeFields GroupBy GroupBy GroupBy Column Combiner Column Combiner Joiner Joiner Joiner Column Rename Column Rename Column Rename Input sum.xlsx73 rowsTransaction Apply DateGet Year, Month Numberand Week Number in YearHours by DayHours by Year-WeekHours by Year-MonthCombine Year-Monthinto a "key"Combine Year:Weekinto a "key"Append Hours for MonthAppend Hours for WeekAppend Hours for DayOutput still has 73 rows :-)Emp Hours for MonthEmp Hours for WeekEmp Hours for WeekExcel Reader String to Date&Time Extract Date&TimeFields GroupBy GroupBy GroupBy Column Combiner Column Combiner Joiner Joiner Joiner Column Rename Column Rename Column Rename

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: @takbb Brian Bates
Created at: 2021-06-24
On NodePit since: 2022-02-06
Last update: 2024-11-21
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!