Alternative node for Math Formula (Multi Column)

Good day,

I am looking for a node which can produce the output below:

 

Col1 Col2 Sum(Col1) Sum(Col2)
0 0 100 150
0 0 100 150
50 0 100 150
50 50 100 150
0 100 100 150

 
 

Basically, I am looking for a single node which can replace 2 Math Formula nodes containing a COL_SUM expression. I tried to use Math Formula (Multi Column); however, the results of the appended columns were the PRODUCT of the sums of Col1 AND Col2:

 

Col1 Col2 Sum(Col1) Sum(Col2)
0 0 15000 15000
0 0 15000 15000
50 0 15000 15000
50 50 15000 15000
0 100 15000 15000

 
 

Any suggestions would be greatly appreciated.
Thank you in advance.
 

-Tanthalas

Hi @Tanthalas and welcome to the KNIME forum,

Use the COL_SUM function with “CURRENT_COLUMN” from the column list.

:blush:

5 Likes

It worked! Thank you! :smile:

2 Likes

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