Icon

Just KNIME It S02 _​ CH04 _​ Spread Yearly Values Across Months

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

Just KNIME It - Season2 - Challenge04: Spread Yearly Values Across Months [ by @Gordon.Haddock ] Yearly Time Stamps Monthly Time Stamps Fiscal Period SELECT[double click] Quarterly Time Stamps RESULTS: spreadequally acrossSELECTED fiscality JKI_S2_CH4 DATA2022_projects.table$Area$ TIME Granularity SELECT[ unselected default -> Yearly ]...Upper == YearlyMiddle == QuarterlyLower == MonthlyProjects AppendMerge Time ParametersMerge Time ParametersTime ParametersMerge Time ParametersGroup YearsGroup QuartersGroup MonthsColumn Names StandardizeColumn Names StandardizeColumn Names StandardizeUpdate ExpendituresTidy up with column sortingTidy up with row sorting Table Reader TIMER Concatenate Joiner Joiner TIME Range Joiner GroupBy GroupBy GroupBy Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Math Formula Column Resorter Sorter Just KNIME It - Season2 - Challenge04: Spread Yearly Values Across Months [ by @Gordon.Haddock ] Yearly Time Stamps Monthly Time Stamps Fiscal Period SELECT[double click] Quarterly Time Stamps RESULTS: spreadequally acrossSELECTED fiscality JKI_S2_CH4 DATA2022_projects.table$Area$ TIME Granularity SELECT[ unselected default -> Yearly ]...Upper == YearlyMiddle == QuarterlyLower == MonthlyProjects AppendMerge Time ParametersMerge Time ParametersTime ParametersMerge Time ParametersGroup YearsGroup QuartersGroup MonthsColumn Names StandardizeColumn Names StandardizeColumn Names StandardizeUpdate ExpendituresTidy up with column sortingTidy up with row sorting Table Reader TIMER Concatenate Joiner Joiner TIME Range Joiner GroupBy GroupBy GroupBy Column Rename(Regex) Column Rename(Regex) Column Rename(Regex) Math Formula Column Resorter Sorter

Nodes

Extensions

Links