Currently depending on the size of data / data structure which I want to get the uniques from I use following:
- Data table column values
- Associative Array (if I'm lazy, but gets slow with lots of values)
- Summarize (a bit better, also slows down)
- Summary table and get values (I can get counts this way if I want to)
- Distribution platform and get values from Report layer (nice thing with this, is that I can get other statistics at the same time and it is fast)
- Lists
- Associative Array
- Insert values to table and use methods mentioned above
My suggestion is to add specific function to get unique values from from data tables and lists in a list/matrix. It could be also data structure like Python's Set (and if were to be data structure
A set is an unordered collection with no duplicate elements. Basic uses include membership testing and eliminating duplicate entries. Set objects also support mathematical operations like union, intersection, difference, and symmetric difference.