Sum the values in fields in a row

I know this will be kind of basic for some, but trying to figure out a way to sum all the values of fields (with a field name that starts with ‘Expertise’) and append the result as a new Column. Each field has an integer value.

e.g.
Expertise - Industry, Expertise - Investment, Expertise - Business
1,1,1

Sum of values = 3

What’s the best way to do something like this?

hi @salja03 & Welcome to the KNIME world,

check out the Column aggregator node…

first select the columns to sum up and then go to the “option” tab and select “Sum”.

This should give you the result for each row.

Greetz, Tommy

5 Likes

Hello @salja03,

if your table structure changes use use Wildcard/Regex Selection to always select/sum all columns starting with “Expertise”.

Br,
Ivan

1 Like

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