Icon

Sum of individual variable columns

Join the appropriate String Manipulation tothe GroupBy depending on whether youwant calendar years or financial years todetermine the Quarters,i.e. Is 2021-01-01:2020Q4 (financial years)2021Q1 (calendar years) sample dataTurn tabulated columns into rows of dataSum by Country and QtrDerive Financial YearQuartersTabulate the datato match originalformatJoin Qtr columnsto end of originaldataDerive Calendar YearQuarters Table Creator Unpivoting GroupBy String Manipulation Pivoting Joiner String Manipulation Join the appropriate String Manipulation tothe GroupBy depending on whether youwant calendar years or financial years todetermine the Quarters,i.e. Is 2021-01-01:2020Q4 (financial years)2021Q1 (calendar years) sample dataTurn tabulated columns into rows of dataSum by Country and QtrDerive Financial YearQuartersTabulate the datato match originalformatJoin Qtr columnsto end of originaldataDerive Calendar YearQuarters Table Creator Unpivoting GroupBy String Manipulation Pivoting Joiner String Manipulation

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: brian
Created at: 2021-08-19
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.4.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!