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

[PankajChaudhary]

I have a table like this

Now I need to find out the total numbers of every individual
like:

[FtmhRahimi]

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

[PankajChaudhary]

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

[FtmhRahimi]

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

[PankajChaudhary]

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

[HansS]

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

[PankajChaudhary]

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