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 !!
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 !!
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
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.
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).