Create monthly values from year values

[TobiP]

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!

[HansS]

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.

gr. Hans

[bruno29a]

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

[HansS]

Good suggesties @bruno29a !

[TobiP]

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