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

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
Screenshot from 2020-12-10 13-39-17

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

@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).

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)

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.)

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


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


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