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,