Basically I’m very new to UiPath & I doesn’t possess with any VB knowledge.
Right now I’m stuck here as I’m trying to get a unique row count for a single column.
As below, I got a range of data, but i would only want to get the unique count of each of the category.
and make it to be able to write down on a same sheet to something like this:
@foxngn
create a report datatable with build datatable activity - dtReport
Columns: Category, Count
use an assign activity
left side: dtReport
Right side:
(From d in YourDataTableVar.AsEnumerable
Group d by k=d("Category").toString.Trim into grp=Group
let ra = new Object(){k, grp.Count}
Select r=dtReport.Rows.Add(ra)).CopyToDataTable
In my case, is there a need to build 2 datatable as shown in the guide file for it to copy?
Also when you mentioned the columns: Category does you meant something like this?
Also if my raw report got alot of other irrelevant column, will this hinder the current activity?