looks like we do it with a group by
Assign activity
LHS: dtResult| datatype: DataTable
RHS
(From d in dtData.AsEnumerable
Group d by k=d("Category").toString.Trim into grp=Group
Where Not k.Equals("cat1")
Select r = grp.First()).CopyToDataTable
looks like we do it with a group by
Assign activity
LHS: dtResult| datatype: DataTable
RHS
(From d in dtData.AsEnumerable
Group d by k=d("Category").toString.Trim into grp=Group
Where Not k.Equals("cat1")
Select r = grp.First()).CopyToDataTable