How to do count in one column

Hello, i want to do count in one column.

1
1
1
2
2

I want to do like below

Number Count
1 3
2 2

Please suggest me some way to do this.

You could add use the "Constant Value Column" node and append a Count column with an IntCell value "1".  The GroupBy node can then be used to group by Number and in the manual aggregation setting you can "Sum" the Count column.  Remember to change the Column naming  to "Keep Original name(s)" and you will get what you want.

Thank you it worked

There is also a Value Counter Node which does just this.

 

1 Like