How to sum up columns of each row data after loop?

[onetonic33]

Hello everyone
I am new here. I need your advice so much
I need to sum up each columns

To understand the node, I made it , but I don’t know how to make it through Loop
If I use the math formula, only one column is added up. I want to know how to use N

For example, Column1+10 = new Column1, Column2+11 =new Column2 …
ColumnN+N+9 = new ColumnN

Please advise how to do it.
Thank you in advance for your help.

[gonhaddock]

Hello @onetonic33 and welcome to the KNIME forum
The specific nodes that allows you to loop through columns are ‘Column List Loop Start’ and ‘Loop End (Column Append)’

Column List Loop Start

Loop End (Column Append)

I hope this is helping you.
BR

[ipazin]

Hello @onetonic33,

to my knowledge there is no simple solution to this kind of column manipulation (simple meaning using function in Math Formula Multi Column node). For ideas check this topic:

Looping over all columns and add/substract between the current column, and the second column

Dear Knime community, I have an excel sheet with 100+ columns, named A,B,C etc. I am trying to create a new excel file that would have the result of A-B, B-C, C-D, … [image] and therefore obtain this: [image] With three columns, it can be done manually. But I have more than a 100 of them, so it’s really not the best method. In the math loop, I can select the $$Current_Column$$, but cannot force the iteration to also selec the $$Current_Column$$ + 1 iteration. The idea would be to write th…

Additionally I have created a workflow example which might do what you need. Take a look and if any questions feel free to ask.
columnN+2_ipazin.knwf (25.5 KB)

Welcome to Community!

Br,
Ivan