Get distinct values from column and write into a list

[divyaag (Divya)]

HI All,

Can anyone help me on how to get distinct values from a column in a datatable to a list or array.
Thank you

[Sasi.lalo (Sasikumar)]

Hi @divyaag,

Kindly check this.

DataTable get all unique values from a column

Hi, what’s the most efficient method to get a list or array of all the unique values in a column from a DataTable? Preferably without looping, thanks

Regards,
Sasikumar K

[divyaag (Divya)]

@Sasi.lalo : it is throwing an error. can you please help

[AshwinS2 (Ashwin S)]

Hi @divyaag

Check this

Datatable dt = Datatable.DefaultView.Totable(true, list of column names)
Thanks
Ashwin.S

[ClaytonM]

Using .net, you could do this:

dt1.AsEnumerable.Select(Function(r) r("columnname").ToString.Trim ).Distinct.ToArray

You can also manipulate it inside the Select if desired. Or, use .Where() before the select to only take rows that meet certain conditions.

Regards.

[balupad14 (Balamurugan)]

Hi ,
It can help you.

How to insert Group by data from old Data table to a new table?

Hi @Jolin, As I understand that you are going to remove the duplicates . In that case you can use the DefaultView from Datatable like below. dtNew=dt.DefaultView.ToTable(True,“Column1”,“Column2”,“Column3”,“Column4”) [Specific columns] or dtNew=dt.DefaultView.ToTable(True) [All the columns] [image] Regards Balamurugan

Regards
Balamurugan.S