How to Remove Duplicate Rows from the Data Table based on specific Column Name using Method Syntax

How to Remove Duplicate Rows from the Data Table based on
specific Column Name Method Syntax

Input:
[Col1,Col2,Col3
AA,ID256,New
BB,ID568,Old
CC,ID569,New
DD,ID785,Old
EE,ID563,New
FF,ID564,Old
AA,ID587,New
BB,ID652,Old
]
Expression:
InputDT.AsEnumerable().GroupBy(Function(x) x.Field(Of String)("Col1")).Select(Function(gl) gl.Last).CopyToDataTable()
Output:
[Col1,Col2,Col3
AA,ID587,New
BB,ID652,Old
CC,ID569,New
DD,ID785,Old
EE,ID563,New
FF,ID564,Old
]

Thanks,

1 Like