UNIQUE function for lists

aeastham
Participant II

When using select, you can specify that the returned list is unique. However, when you combine lists using addition, there is no way to ensure the resulting values in the list are unique. It would be good to have a UNIQUE() function that you could pass a list to which would remove duplicates. Another good version of this would be to add a “remove duplicates” parameter to the sort function.

Status Open
0 8 549
8 Comments
Jonathon
Participant V

In my experience, you can make a list unique by subtracting a blank list from it.

For example:

SELECT(table[id],TRUE)-LIST()

Will return a list of unique items in the table.

aeastham
Participant II

Thanks Jonathan.

That works perfectly.

Cheers,

Andy

Steve
Participant V

Note that @Jonathon’s suggestion (that I myself use in my own apps) is not supported behavior, so it may change in the future without notice.

aeastham
Participant II

I agree Steve. It would be better to have an actual documented function to this.

Cheers,

Andy

MultiTech
Participant V

I have need for this as well, but my data set is too large to afford a SELECT() on it; I really need a way to take a list and say - give me a list of the options here.

Jonathon
Participant V

This feature request has been added:

There should be a way to archive these

Status changed to: Open
Pratyusha
Community Manager
Community Manager
 
Status changed to: Open
Pratyusha
Community Manager
Community Manager