Hi Team, I want this query for group by, but i dont want to sum the group by but concat it with a comma in between. Please help. (From d In dt.asenumerable Group d By k1=d(6). toString.trim, k2=d(8).toString.trim Into grp=Group Let s= grp.Sum(Function (x) CDbl(x(13).toString)) Let ra = New Obje…

Hi @yash.choursia Use the below linq expression (From d In dt.AsEnumerable() Group d By k1 = d(6).ToString().Trim(), k2 = d(8).ToString().Trim() Into grp = Group Let s = String.Join(",", grp.Select(Function(x) x(13).ToString())) Let ra = New Object() {k1, k2, s} Select dtResult.Rows.Add(ra)).CopyT…

LINQ group by but concating instead of summing

Help Studio

ppr (Peter Preuss) July 24, 2023, 9:56am 7

Topic		Replies	Views
Linq Group By and Sum Help datatable , studio	13	18537	April 26, 2020
Linq group by and concatenate Studio	3	1730	August 26, 2022
LINQ to concat strings by comma Something Else feedback	5	2929	August 28, 2021
Linq query for groupby and sum Studio	15	19263	April 27, 2020
Linq query group by and sum Studio datatable , excel , studio	7	3721	February 9, 2021

LINQ group by but concating instead of summing

Related topics