JKC 7
SpreadYearly Values Across Months
Yourteam created a summary of the total amount spent last year on each project. Thedata looks like the following:
Year Area Project exp
2022 area A projA 120
2022 area B projX 160
Thefinance department of your company, however, would like to have a more granularoverview of the expenditures. In particular, the expenditures for projects inarea A should be spread equally across 12 months, while those for projects inarea B should be grouped by quarters. In the end, the above table should looklike the following:
Year Area Project exp
2022 area A projA jan 10
2022 area A projA feb 10
...
2022 area B projX Q1 40
2022 area B projX Q2 40
Dataset: ExpendituresData on KNIME Community Hub
Nodes
Extensions
Links
- No links available