Linq query group by rows and group the value

Help Studio
, ,
2

@Gashu.REMUS
Welcome to the forum

give a try on following:

  • prepare an empty datatable - assign activity:
    left side: dtReport
    right side: YourOriginDatatableVar.Clone

  • use an assign activity:
    left side: dtreport
    right side:

(From d in YourOriginDatatableVar.AsEnumerable
Group d by k=d("GroupID").toString.Trim into grp=Group
let n = String.Join(",",grp.Select(Function (x) x("Value1").toString.Trim).Distinct())
let p = String.Join(",",grp.Select(Function (x) x("Value2").toString.Trim).Distinct())
let ra = new Object(){k,n,p}
Select dtReport.Rows.Add(ra)).CopyToDataTable
4 Likes