Icon

JKISeason2-4

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

Challenge 04: Spread Yearly Values Across MonthsLevel: EasyDescription: Your team created a summary of the totalamount spent last year on each project. The data looks likethe following:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, wouldlike to have a more granular overview of the expenditures.In particular, the expenditures for projects in area A shouldbe spread equally across 12 months, while those forprojects in area B should be grouped by quarters. In theend, 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 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Node 17 Table Reader Row Splitter Math Formula Math Formula Create Date&TimeRange Extract Date&TimeFields GroupBy Cross Joiner Cross Joiner Column Filter Column Resorter Column Combiner Column Rename Column Resorter Column Combiner String Manipulation Concatenate Challenge 04: Spread Yearly Values Across MonthsLevel: EasyDescription: Your team created a summary of the totalamount spent last year on each project. The data looks likethe following:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, wouldlike to have a more granular overview of the expenditures.In particular, the expenditures for projects in area A shouldbe spread equally across 12 months, while those forprojects in area B should be grouped by quarters. In theend, 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 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Node 17 Table Reader Row Splitter Math Formula Math Formula Create Date&TimeRange Extract Date&TimeFields GroupBy Cross Joiner Cross Joiner Column Filter Column Resorter Column Combiner Column Rename Column Resorter Column Combiner String Manipulation 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: h.mann
Created at: 2023-04-19
On NodePit since: 2023-04-23
Last update: 2024-11-21
Created with KNIME version: v4.7.1
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!