Need to group data in datatable

Help Activities
, ,
1

Hi All,

I have data in datatable type variable. And here “policynumber” column has duplicate values. So, I need to group this.

image
image1605×181 16.2 KB

Any suggestions?

2

Hey,

What action do you want to take with the duplicate values? Just highlight any policy numbers which have duplicates?

Cheers,
Josh

3

grouping by policy number.

Output would be like :-

image
image1582×53 4.68 KB

image
image1588×26 2.63 KB

image
image1568×58 4.88 KB

4

Hi @shuklarchana001 ,

Is this what you were looking for?

image

dt_sampleData.AsEnumerable.GroupBy(Function(g) g("PolicyNumber").ToString.Trim).Select(Function(s) s.CopytoDataTable).ToList()

image

GroupandSeperate.xaml (10.3 KB)

Kind Regards,
Ashwin A.K

5

Hi @shuklarchana001,

Give @ashwin.ashok’s answer a go.

If you simply just wanted to order the data, which would group duplicate PolicyNumbers, but keep it all in one DataTable, try this:

yourDT.AsEnumerable.OrderBy(function (x) x.Item("PolicyNumber")).CopyToDataTable

Kind Regards