Variable Header for column calculation

I am passing a list of columns and wanted an additional column in my data which will have the summation of the columns provided in the list.

like example :
I pass a string list of column headers that I want the summation of (mostly list box input) : “A”, “B”, “C”

in the output, I need all the existing columns plus an additional column D ( = A+ B + C).

I could use column expression I guess, but I am stuck at the part that the number of entries itself will be dynamic. like some time it will be 3 entries and other time it will be 5 entries.

Is there any way using Knime only node to achieve this?

Hi @Loke2707

Take a look at the Column Aggregator node.
gr. Hans

2 Likes

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