JKISeason2-4_tark
Challenge 04: Spread Yearly Values Across Months
Level: Easy
Description: 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
...
Authors: hanss and bruno29a
Dataset: Expenditures Data on KNIME Community Hub
Nodes
- String Manipulation3 ×
- Constant Value Column2 ×
- Math Formula2 ×
- One Row to Many2 ×
- RowID2 ×
- Show all 12 nodes
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)