How to get the first occurrence for a word

Help Activities
, ,
4

@Karam_Abulawii
prepare a datatable with build datatable activity - dtStatistic
Cols: Status, Count

Assign activity:
left side: dtStatistic
right side:

(From d in YourDataTableVar.AsEnumerable
Group d by k=d(“Status”).toString.Trim into grp=Group
Let ra = new Object(){k, grp.Count}
Selet r= dtStatistic.Rows.Add(ra)).CopyToDataTable

it will create for a statistic dynamily on all occuring status values

Also have alook here:

2 Likes