I have many many columns and would like to calculate their sumproduct. Just like Excel...


How would one go about doing that in Knime? Can't figure out by myself and (strangely) nobody seems to have asked for this before

Nobody? :-(

I'm stuck for two days trying to figure this out with loops, java snippets and so on...but there's always a barrier somewhere I can't get through.

I feel like there has to be an easy solution for something common like a Sumproduct

Hi Bernadors,

sorry, sometimes we need more time for answering :)

To do a sumproduct in knime you need to use two steps.

First use the math formula node to do the product

Afterward use the groupby node to calculcate the sum of all products.

Cheers, Iris