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

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

Hi @rahul_rai

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

Check the count as

Datatable.rows.count.toString

Thanks
Ashwin S

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

Hi @rahul_rai

Check this linq

Thanks
Ashwin S