Alternative node for Math Formula (Multi Column)

[Tanthalas]

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

[armingrudd]

Hi @Tanthalas and welcome to the KNIME forum,

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

[Tanthalas]

It worked! Thank you!