JKC 7

0 ×

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

• Cross Joiner2 ×
• Math Formula2 ×
• Table Creator2 ×
• Concatenate1 ×
• Row Splitter1 ×
• Space Connector1 ×
• Table Reader1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Server Client

Links

• No links available