Sum up rows

[SeMo]

Hello,

So I have this table:
|Image number | well | site | Count nuclei|
|1 | B10 | 1 | 15 |
|2 | B10 | 2 | 25 |
|…
|25 | B10 | 25 | 50 |
|26 | B11 | 1 | 15 |

And I would like to add a column with the total count nuclei per well (I always have 25 sites per well so image number 1 to 25 correspond to B10, 26-50 to B11…):

|Image number | well | site | Count nuclei| Total nuclei per well
|1 | B10 | 1 | 15 | =15+25+…
|2 | B10 | 2 | 25 |
|…
|25 | B10 | 25 | 50 |
|26 | B11 | 1 | 15 |=15+…

A detailed answer would be much appreciated!

Thanks for your help

Selma

[Aswin]

Try the Column Aggregator node.

[ipazin]

Hi there!

You can try GroupBy node as you have well as a grouping column. To add sum values back to original data you can use Joiner node. Take a look at the picture and attached workflow.

2019_01_28_Sum_per_Groups.knwf (12.5 KB)

Have a nice day,
Ivan

[SeMo]

It is working perfectly thanks a lot!

Selma