How to group rows with similar data in a table

[manojj.yadav (Anonymous)]

Hi, I have a table called TABLE1 with below columns,
COLUMN1 COLUMN2
aaa 111
bbb 555
aaa 222
bbb 777
ccc 888
aaa 999

I want to group them based on COLUMN1, like:
aaa 111
aaa 222
aaa 999
bbb 555
bbb 777
ccc 888

Is there a way to do it?

[Gokul001 (Gokul Balaji)]

HI @manojj.yadav

Check out this expression

DtRead.AsEnumerable().OrderBy(Function (row) row("Column1").ToString).Select(Function (row) row).ToArray.CopyToDatatable()

Check out this Video link

LINQ | Sort Datatable Using LINQ | LINQ Uipath Tutorials | Coderslobby

Regards
Gokul

[manojj.yadav (Anonymous)]

Sure, will checkout and see.

[Gokul001 (Gokul Balaji)]

HI @manojj.yadav

Check out the XAML file

SortDt.xaml (7.9 KB)

Output snap

Regards
Gokul

[ppr (Peter Preuss)]

@manojj.yadav

I want to group them based on COLUMN1, like:

Currently the output looks like only sorted. So Goku shared some approaches with you.

• LINQ
• Sort DataTable Activity
  …

When it is about forming groups we can do with a group by

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Gokul001 (Gokul Balaji)]

Hi @manojj.yadav

Check out this thread for group by expression

Removing duplicates based on one Column

Hi @mz3bel How about this expression ? DtOutput = DtBuild.Clone (From d In DtBuild.AsEnumerable Group d By k=d("Col A").toString.Trim, k2=d("Col B").ToString.Trim Into grp = Group Let ra = New Object(){k,k2} Select r = DtOutput.Rows.Add(ra)).CopyToDataTable Regards Gokul

Need a help on Group By

Hi @Marian_B Try this expression Dt.AsEnumerable().GroupBy(Function(r) Tuple.Create(r("colName1"),r("colName2"))).Select(Function(g) g.First).CopyToDataTable Regards Gokul