Assign Activity
LeftSide: dtResult | DataType: DataTable
Right side:
(From d in YourDataTableVar.AsEnumerable
Group d by k=d(“Customer ID”).toString.Trim into grp=Group
let s = grp.Sum(Function (x) CInt(x(“Values”).toString)
Where s >= 100
Select grp.toList).SelectMany(Function (m) m).CopyToDataTable
For handling empty result in a defensive way we can use following pattern: