I had 2 datatable. one has list of owner and other has project which are assigned to owner

Help Studio
, ,
2

Hi @Puneet_Singh

Dtclone= (From d In Dt.AsEnumerable()
Group d By k=d("owner").toString.Trim Into grp = Group
Let count = grp.count
Let ra = New Object(){k,count}
Select r = DtClone.Rows.Add(ra)).CopyToDataTable()

Use this in assign

Dt is your orginal datatable

Dtclone is the new datatable

Here its grouping on owner column and counting the number of records for each group

Cheers