I have a table like this
Now I need to find out the total numbers of every individual
like:
I have a table like this
Now I need to find out the total numbers of every individual
like:
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).
@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)
@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.)
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.