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?
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.
3 Likes
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)
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.