Need to fetch multiple columns from a data table using Linq query

Help Activities
, ,
4

Try this one:

(From d In File_Table.AsEnumerable
Group d By k=d(“SF-Case”).toString.Trim Into grp=Group
Let n = String.Join(“,”,grp.Select(Function (x) x(“Item”).toString.Trim).toArray)
Let p = String.Join(“,”,grp.Select(Function (x) x(“Status”).toString.Trim).toArray)
Let ra = New Object(){k,n,p}
Select dtreport.Rows.Add(ra)).CopyToDataTable

image

Refer link: [HowTo] Overview on different options for grouping data and processing the groups - News / Tutorials - UiPath Community Forum