Icon

JKISeason2-4 Spread Yearly Values Across Months Jose De Souza

JKISeason2-4 Jose De Souza

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 total amountspent last year on each project. The data looks like thefollowing:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, would liketo have a more granular overview of the expenditures. Inparticular, the expenditures for projects in area A should bespread equally across 12 months, while those for projects inarea B should be grouped by quarters. In the end, the abovetable 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 81Monthly Area ANode 83Node 84Node 85Node 86 Table Reader Table Creator Joiner Math Formula Column Filter Sorter Challenge 04: Spread Yearly Values Across MonthsLevel: EasyDescription: Your team created a summary of the total amountspent last year on each project. The data looks like thefollowing:Year Area Project exp2022 area A proj A 1202022 area B proj X 160The finance department of your company, however, would liketo have a more granular overview of the expenditures. Inparticular, the expenditures for projects in area A should bespread equally across 12 months, while those for projects inarea B should be grouped by quarters. In the end, the abovetable 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 81Monthly Area ANode 83Node 84Node 85Node 86 Table Reader Table Creator Joiner Math Formula Column Filter Sorter

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: USUARIO
Created at: 2023-03-29
On NodePit since: 2023-04-21
Last update: 2024-05-03
Created with KNIME version: v4.7.1
Tags: JustknimeitJKISeason2-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!