How to keep unique values in list

Help Activities
, ,
1

Hi

I want my list to have only unique values

String.Join(“;”, Array.ConvertAll(DT.Select().Distinct().ToArray(), Function(row) row(“Order”).ToString))

I tried to use distinct but still doesn’t work

2

@adext,

Use this snippet

String.Join(";", (From row In DT.AsEnumerable() Select row.Field(Of String)("Order")).Distinct().ToArray())

3

no it doesn’t work :frowning:

4

@adext,

It’s working. May be you are expecting something else.

The image shows a workflow in UiPath where a data table is built and a log message activity combines distinct "Order" field values from the data table into a semicolon-separated string. (Captioned by AI)
The image shows a workflow in UiPath where a data table is built and a log message activity combines distinct "Order" field values from the data table into a semicolon-separated string. (Captioned by AI)1086×468 17.5 KB

Input datatable:

A data table creation interface showing columns for "Id" and "Order," with the "Id" values ranging from 1 to 7 and corresponding "Order" values "O1," "O2," and "O3." (Captioned by AI)
A data table creation interface showing columns for "Id" and "Order," with the "Id" values ranging from 1 to 7 and corresponding "Order" values "O1," "O2," and "O3." (Captioned by AI)854×594 24.3 KB

Output:

The image shows the debug output window of a software development environment, indicating that the debug process for the file "Main" has started and displaying a message about the start of "GenAI Demo execution" and output "O1;O2;O3". (Captioned by AI)
The image shows the debug output window of a software development environment, indicating that the debug process for the file "Main" has started and displaying a message about the start of "GenAI Demo execution" and output "O1;O2;O3". (Captioned by AI)766×333 10.8 KB

See the unique values from Order columns are printed.

5

then give details on what is the input and what is the failing output

In General we recommend also to trim/harmonize the values

e.g. getting a flat string like:

String.Join(";", dtData.AsEnumerable().Select(Function (x) x("Order").toString.Trim).Distinct())
6

@adext

Please try this

string.Join(";",Dt.AsEnumerable.GroupBy(function(x) x("Order").ToString.Trim.ToLower).Select(function(x) x.First(function(y) y("Order").ToString)))

Could directly use select with groupby expression and then distinct…but wanted to preserve atleast one format

Cheers