give a try at
Assign activity
dtFiltered =
(From d in YourDataTableVar.AsEnumerable
Group d By d(0).toString.Trim Into grp=Group
Let gFilter = grp.Where(Function (x) x(1).toString.ToUpper.Equals("IS FOUND"))
Let gFinal = If(gFilter.Count > 0, gFilter, grp)
From g In gFinal
Select r = g).CopyToDataTable
Find starter help here:
GroupBy_1Col_FilterMembers-WhenCheckOK.xaml (7.1 KB)
About LINQ and GroupBy have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum