Icon

JKISeason2-04_​rev00

JKISeason2-4_rev00

There has been no description set for this workflow's metadata.

Your team created a summary of the total amount spent last year on each project. The datalooks like the following:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, would like to have a more granular overviewof the expenditures. In particular, the expenditures for projects in area A should be spreadequally across 12 months, while those for projects in area B should be grouped by quarters. Inthe end, the above table should look like the following:Year Area Project exp2022 area A proj A jan 102022 area A proj A feb 10...2022 area B proj X Q1 402022 area B proj X Q2 40 Node 1Node 2Node 3Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 14Node 15Node 16Node 17Node 18Node 19 Table Reader Table Rowto Variable Create Date&TimeRange String Manipulation(Variable) Extract Date&TimeFields Column Expressions Row Splitter Column Expressions Cross Joiner Cross Joiner Concatenate GroupBy Column Renamer Column Filter Column Renamer Column Filter Column Resorter Your team created a summary of the total amount spent last year on each project. The datalooks like the following:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, would like to have a more granular overviewof the expenditures. In particular, the expenditures for projects in area A should be spreadequally across 12 months, while those for projects in area B should be grouped by quarters. Inthe end, the above table should look like the following:Year Area Project exp2022 area A proj A jan 102022 area A proj A feb 10...2022 area B proj X Q1 402022 area B proj X Q2 40 Node 1Node 2Node 3Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 14Node 15Node 16Node 17Node 18Node 19Table Reader Table Rowto Variable Create Date&TimeRange String Manipulation(Variable) Extract Date&TimeFields Column Expressions Row Splitter Column Expressions Cross Joiner Cross Joiner Concatenate GroupBy Column Renamer Column Filter Column Renamer Column Filter Column Resorter

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: alxpei77
Created at: 2023-04-23
On NodePit since: 2023-04-23
Last update: 2024-04-27
Created with KNIME version: v5.0.0
Tags: JKISeason2-4

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

Try NodePit Runner!