Icon

JKI2- Challenge 04

Just Knime It Season 2- Challenge 04

Your team created a summary of the total amount spent last year on each project. The data looks like the following:

Year Area Project exp
2022 area A proj A 120
2022 area B proj X 160

The finance department of your company, however, would like to have a more granular overview of the expenditures. In particular, the expenditures for projects in area A should be spread equally across 12 months, while those for projects in area B should be grouped by quarters. In the end, the above table should look like the following:

Year Area Project exp
2022 area A proj A jan 10
2022 area A proj A feb 10
...
2022 area B proj X Q1 40
2022 area B proj X Q2 40

Your team created a summary of the total amount spent last year on each project. The data looks 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 overview of the expenditures. In particular, the expenditures for projects inarea A should be spread equally across 12 months, while those for projects in area B should be grouped by quarters. In the end, the above table should looklike 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 Read TableSplit Table by AreaCreates Rangeof MontheCreates Rangeof QuartersGets Months NamesGets Quarter NumberCreates QuarterDescriptionArea A - Exp by MonthArea B - Exp by QuarterChange Column NameCreates One Line By Monthfor Each ProjectFilter Out Intermediate ColumnsFilter Out Intermediate ColumnsCreates One Line By Quarterfor Each ProjectWrites Final Table Table Reader Row Splitter Create Date&TimeRange Create Date&TimeRange Extract Date&TimeFields Extract Date&TimeFields String Manipulation Math Formula Math Formula Column Rename Cross Joiner Column Filter Column Filter Cross Joiner Concatenate Column Resorter Table Writer Your team created a summary of the total amount spent last year on each project. The data looks 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 overview of the expenditures. In particular, the expenditures for projects inarea A should be spread equally across 12 months, while those for projects in area B should be grouped by quarters. In the end, the above table should looklike 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 Read TableSplit Table by AreaCreates Rangeof MontheCreates Rangeof QuartersGets Months NamesGets Quarter NumberCreates QuarterDescriptionArea A - Exp by MonthArea B - Exp by QuarterChange Column NameCreates One Line By Monthfor Each ProjectFilter Out Intermediate ColumnsFilter Out Intermediate ColumnsCreates One Line By Quarterfor Each ProjectWrites Final Table Table Reader Row Splitter Create Date&TimeRange Create Date&TimeRange Extract Date&TimeFields Extract Date&TimeFields String Manipulation Math Formula Math Formula Column Rename Cross Joiner Column Filter Column Filter Cross Joiner Concatenate Column Resorter Table Writer

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: faber
Created at: 2023-04-24
On NodePit since: 2023-04-27
Last update: 2024-04-27
Created with KNIME version: v4.7.2
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!