Function to sort arrays

I’ve searched through the forum, and saw multiple posts about this with no answer, so I assume this is not supported currently. Hence the feature request.

Basically, I want a way to sort an array. One example use case is with ARRAYUNIQUE(). Currently, the ordering of the array returned depends on the order of the rows in the table. This is not a very desirable property for a rollup column meant to summarize a set of values. If there was a SORTED function, I could call that and make sure the value in my summary column didn’t depend on the order of rows somewhere else.

Please consider adding a SORTED() function. Thanks.

5 Likes