Create monthly values from year values

Hi!

I would like to “expand” (?) my year values to monthly values by adding a “Month” column, dividing the expenditure by 12 and then spread the values over the newly created 12 months, see screenshot for reference. The first table is what I have now, the second table is what I would like KNIME to create.

Thanks in advance!

Hi @TobiP

See this wf create_value_from_year.knwf (20.2 KB) . I added an additional table with all months in a year. With the CrossJoiner node it creates all possible combinations for your input and the 12 months.
image
gr. Hans

5 Likes

Hi @HansS , probably do the Math Formula right after the input before the cross joiner instead of at the end

2 Likes

Good suggesties @bruno29a !

1 Like

Great, I didn’t know about the Crossjoiner. Thank you!

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.