Any similar collection can work like "set"?

Hi, I found that it looks doesn’t have any similar collection can role like “set” to collect data without duplicate data?
Does anyone know any idea to solve this problem?

Thanks in advance !!

@opas1216

Could you please tell more details about the issue for better understanding and also tell me what’s the input type.

I want to collect the data in specific column from excel, but need to remove duplicate items.
For example: “Project”: aaa, bbb, ccc, ddd, aaa, ccc => Result: aaa, bbb, ccc, ddd

@opas1216

Try this :

         newDT = varDT.DefaultView.ToTable(True,"ColumnName").CopyToDataTable

The above expression will delete all duplicate rows based on the column name and will give unique records.

1 Like

You can use all of .NET types in UIPath.
Therefore you can use, for instance, HashSet.

On the Variable tab, when selecting a type you can browse for Collections.Generic.HashSet and declare whatever type you need the set to be of (Strings, Integers, etc).