LINQ group by 3 columns but display all of them

[drago47]

Hello!

I have a table…

And I want to group by Col2 and Col9
And the output should be

(From d In dt.AsEnumerable
Group d By k1=d("Col1").toString.Trim, k2=d("Col2").toString.Trim Into grp=Group
Let ra = New Object(){k1,k2, ? ? ? ? ? }
Select test.Rows.Add(ra)).CopyToDataTable

I ve tried the code above only with k1 and k2… but i need all columns

[ppr (Peter Preuss)]

its depending on how you have decide from which group member to take the value
in case of taking it from first group member we would use for ?
grp.First()(YourColNameOrIndex)

[drago47]

@ppr yeah! first would be nice so… let me give a shot.

[ppr (Peter Preuss)]

but keep in mind your output

@drago47

And the output should be

looks more as it is taking the distinct rows, where the distinct value evaluation is done over all row columns

[drago47]

yes, you are totally right. to avoid losing distinct data - those columns need to be included in the group by. Correct?

[ppr (Peter Preuss)]

we can do:

• using remove duplicate row activity
• YourDataTableVar.DefaultView.ToTable(True, {ColNameFirst,ColNameLast})
• LINQ

Also have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Introduction In the majority of scenarios duplicated / Non duplicated rows can be identified by a few columns grace to the key column concept. In order to retrieve it, the group by approach helps It can be done e.g. with some nice components from Connect or LINQ In some scenarios all duplicated / non duplicated rows should be detected by checking all columns. Setting up an approach without explicit listing all column names or column index would speed up the implementation. Implementat…