Icon

JKISeason2-4

Challenge 04: Spread Yearly Values Across Months

Challenge 04: Spread Yearly Values Across MonthsLevel: EasyDescription: 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 forprojects 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 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 Spread Yearly Values Across Months DataArea Splitterloop for any projectproject filterCreate 12 months and 4 quartersspread equally across 12 months,MonthFull Dataquarters filterYear / AreaProject Period / expQuarterFull Datamonth filterYear / AreaProject Period / exploop for any projectproject filterspread equally across 4 quarters,filter missingNode 17Node 18Node 19Node 20Union Months & Quarters Table Reader Row Splitter Table Row ToVariable Loop Start Row Filter Table Creator Math Formula Cross Joiner Column Filter Column Resorter Cross Joiner Column Filter Column Resorter Table Row ToVariable Loop Start Row Filter Math Formula Row Filter Loop End Loop End Column Rename Column Rename Concatenate Challenge 04: Spread Yearly Values Across MonthsLevel: EasyDescription: 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 forprojects 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 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 Spread Yearly Values Across Months DataArea Splitterloop for any projectproject filterCreate 12 months and 4 quartersspread equally across 12 months,MonthFull Dataquarters filterYear / AreaProject Period / expQuarterFull Datamonth filterYear / AreaProject Period / exploop for any projectproject filterspread equally across 4 quarters,filter missingNode 17Node 18Node 19Node 20Union Months & QuartersTable Reader Row Splitter Table Row ToVariable Loop Start Row Filter Table Creator Math Formula Cross Joiner Column Filter Column Resorter Cross Joiner Column Filter Column Resorter Table Row ToVariable Loop Start Row Filter Math Formula Row Filter Loop End Loop End Column Rename Column Rename 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: ardda
Created at: 2023-04-21
On NodePit since: 2023-04-21
Last update: 2024-11-18
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!