Distinct rows from data table

Help
1

I have extracted below excel data to datatable and want to filter as follow:
I want to get distinct records based on Max age.

Pls help me with this.

image

1 Like
2

try this
dataTable.DefaultView.ToTable(true, “ColumnName”)

3

I want to get all distinct records based on file name and max age.
With that query I will get only one column with distinct ages

4

@Sreeja26,

Please try below expression:

DataTableName.AsEnumerable.GroupBy(Function(r) New with {Key.Record = r(“File”)}).Select(Function (g) g.OrderByDescending(Function(r) r(“AGE”)).First()).CopyToDatatable()

1 Like
5 
                   It is  Function (r)
6

With this query, I am getting the following:
image

7

I would like to get below (without red coloured cells)
image

8

Can someone help me

9

Hi @Sreeja26,

Try below code

((From LineNo In dt.DefaultView.ToTable(True,"ID").Select().ToList() Select (From row In dt.Select Orderby row("AGE") descending Where row("ID").ToString=LineNo("ID").ToString Select row).ToList(0)).ToList()).CopyToDatatable()

Regards,
Arivu :slight_smile:

10

Thank you @arivu96
But I am getting following error. Pls let me know if i am missing anything:

image
image741Ă—256 12.8 KB

11

The query is correct only but make it Orderby is Order by.
i missed the space

((From LineNo In dt.DefaultView.ToTable(True,"ID").Select().ToList() Select (From row In dt.Select Order by row("AGE") descending Where row("ID").ToString=LineNo("ID").ToString Select row).ToList(0)).ToList()).CopyToDatatable()

Flowchart.xaml (13.0 KB)

Regards,
Arivu :slight_smile:

2 Likes
I want get distinct rows on the basis of two columns
13

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