LinQ to adquire the unique values in a Column DataTable and create a List With all that Values

[Fabio_Villamil]

Hello I have this input:

And the output that I want is:
Array_Names={“Alex”,“Dante”,“Vergil”}

[ppr (Peter Preuss)]

dtData.AsEnumerable().Select(Function (x) x("COLUMN1").toString.trim).Distinct().toArray

[vrdabberu (Varunraj Dabberu)]

Hi @Fabio_Villamil

Try this:

=> Read Range Workbook

Output-> dt

=> Use Below syntax in Assign:

uniqueNames = dt.AsEnumerable().Select(Function(row) row.Field(Of String)("COLUMN1").Trim()).Where(Function(name) Not String.IsNullOrEmpty(name)).Distinct().ToArray()

uniqueNames is of dataType Array(System.String)

=> You can print it in Message Box or Log Message String.Join(", ", uniqueNames)

Regards