Suppose I have deparment coulmn and emp against the dept ,I want to see count of emp belong to which depart using uipath

Help
1

Suppose I have deparment coulmn and emp against the dept ,I want to see count of emp belong to which depart

2

Hi @rahul_rai

Use Datatable=Datatable.Select(“[Department]=‘IT’”).CopyToDatatable()

Check the count as

Datatable.rows.count.toString

Thanks
Ashwin S

3

Hello Ashwin ,thanks for the prompt response but I dont want to hardcode the value like your case IT ,if i Have 100 Department I dont want to put all .
like .
DepartName :emp_count
CS : 4
IT : 5
EC : 6
.
.
.

4

Hi @rahul_rai

Check this linq

Thanks
Ashwin S