FunctionsArray

array_enumerate_dense

Assigns the first distinct value id 1, next unseen value id 2, and so on, then returns each element's dense id.

array_enumerate_dense(…) → String

Kind · scalar

Assigns the first distinct value id 1, next unseen value id 2, and so on, then returns each element's dense id.

Part of the Array family.

array_enumerate

Returns [1,2,...,n] for each input array, matching the one-based position of every element.

array_enumerate_dense_ranked

Returns dense ids by first-seen value order and keeps equivalent values on the same id.