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

jack.chan (Jack Chan) November 14, 2022, 3:49pm 2

this will give distinct column1 values as a list

DatatableName.AsEnumerable.Select(function(row) row.Field(of String)("Column1")).ToList.Distinct

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