How can i add all the rows of data for any particular column?

KNIME Analytics Platform
#1

I have a table like this
Screenshot from 2020-12-10 13-35-51

Now I need to find out the total numbers of every individual
like:
Screenshot from 2020-12-10 13-39-17

#2

Hi @PankajChaudhary
I think you can do this by using the “Column Aggregator” node. see below workflow:
columns aggregation.knwf (10.6 KB)

#3

@FtmhRahimi According to this workflow, the output column is Maths, Hindi, geography(m, h, g) but I need Sonu, Monu, and Ronu(s, m, r).

#4

@PankajChaudhary
This can also be solved by using “Extract Column Header” and “Insert Column Header”, I changed the workflow a little, see this:
columns aggregation.knwf (13.3 KB)

#5

@FtmhRahimi
This workflow is adding the whole hindi grades, whole maths grades and geo… grades
but in above example we need sum grades of candidate (The workflow adding horizontally but we need vertically.)

#6

How about a GroupBy sum_vertical.knwf (10.8 KB)
gr, Hans

2 Likes
#7

Thanks @HansS and @FtmhRahimi the GroupBy node worked in my case.

2 Likes
#8

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