Multiply several rows

[LuisMP]

Hi, I’m trying to multiply several rows at the time and don’t know really how to do it. I’m fairly new to Knime. The data looks like this:

What I want to do is multiply R1 with C1, R2 with C2 and so on… any ideas?

[Andrew_Steel]

Hi @LuisMP,

you could transpose the table and then use some MathFormular nodes.

Best Regards
Andrew

[Thyme]

Or extract the number from the identifier ("Total") and use it in a GroupBy node as grouping column. "Product" is one of the aggregation methods, this should work out.

[rolandnemeth]

hello @LuisMP,

please have a look at the attached workflow and init data.

I hope it helps.

Best Regards,
Roland

init_data.xlsx (9.3 KB)

multiply_totalpairs_by_month.knwf (60.0 KB)