Hi, I have a table which has duplicate values in it. I want to get distinct values from it. I used the below function. DatatableName.DefaultValue.Totable(True,Column1,Column2,Column3,Column4) This gives me Unique value corresponding to the 4 columns mentioned above. But I want to get Unique Val…

Get distinct Values from a Data table

omer.ozturk (Ömer Öztürk) November 14, 2022, 4:44pm 4

This code will delete the duplicate value and get the first match.

Please try this.

dtVar.AsEnumerable().GroupBy(Function(x) x.Field(of String)(“ColumnName”)).Select(Function(y) y.First()).CopyToDataTable

Regards
Ömer

Topic		Replies	Views
Get distinct values from column and write into a list Help	5	16674	September 12, 2019
I have a datatable with 3 columns How to find distinct values in one column of data table and output to be 3 column datatable as follows Studio datatable , activities , question , foundation_training	8	7514	January 26, 2023
DataTable get all unique values from a column Help	15	38005	December 27, 2023
Retrive unique value from datatable w.r.t Column name along with remaining Data Academy Feedback	0	658	October 27, 2020
Distinct values in a datatable Help datatable	10	29172	April 26, 2022