How to assign all the unique values to diff variables

I am looking to get and assign all the unique available values of a column to separate variables, so that i can use anywhere in the Sequences

Uipath

Have to get all the unique values from Col2 and assign to separate variables.

For Eg:
Var1= 245
Var2=226
Var3=28990

Please suggest the possible ways to get the same.

HI @mayankjha986

Try this expression

(From p in io_TransactionData.Select() where( From q in io_TransactionData.Select() where q(“Col2”).Equals(p(“Col2”)) Select q).ToArray.Count=1 Select p).ToArray.CopyToDataTable()

And write this other sheet

Regards
Sudharsan