Query To Count Number Of Requester For Each Priority Type

hey everyone. Need a quick response.
i have this excel sheet where some requester names and their priorities are mentioned.
So what we need to do is ,to count the no. of requester for all the individual priority type.
for eg. in priority 1 there are 10 requester and so on. please suggest me some ways .

Hi @Debasmita,

Group by priority then take the count

DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, “Priority”)

loop through the distinctValues datatable using for each

inside for each


1 Like

How to create dataview in uipath?

Assign View = New DataView(myTable) as a DataView variable;
View.Sort = “Column1, Column2,Column3 DESC”. @Debasmita



Dictionarty=( From p in dta.Select
group p by Department=p.Item("Priority") Into GroupA=Group
Select GroupA).ToDictionary(Function(x) x(0)("Priority").ToString, Function(x) Convert.ToString(x.Count))) 

Now you can access the count by using the priority.

Refer this post for more details