LINQ group by but concating instead of summing

Help Studio
, ,
1

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 Object(){k1,k2,s}
Select dtResult.rows.add(ra)).copytodatatable

This query is summing the rows but i want it to for cacating with comma in between. Please help.

2

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)).CopyToDataTable()

Hope it helps!!

1 Like
3

Hi @yash.choursia

(From d In dt.asenumerable
Group d By k1=d(6). toString.trim, k2=d(8).toString.trim Into grp=Group
Let ra = New Object(){k1,k2,string.Join(“,”, grp.Select(Function (x) x(13).toString))}
Select dtResult.rows.add(ra)).copytodatatable

Hope it helps!!

4

Hi @yash.choursia

Try this syntax:

(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)).CopyToDataTable()

Hope it works!!

5

Hi @yash.choursia

Try this

(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)).CopyToDataTable()

Regards,

6

@yash.choursia

This is how it looks

(From d In dt.asenumerable
Group d By k1=d(6). toString.trim, k2=d(8).toString.trim Into grp=Group
Let s= Sring.Join(",",grp.Select(Function (x) x(13).toString))
Let ra = New Object(){k1,k2,s}
Select dtResult.rows.add(ra)).copytodatatable

cheers

7
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.