FunctionsArray

array_enumerate_dense_ranked

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

array_enumerate_dense_ranked(…) → String

Kind · scalar

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

Part of the Array family.

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_uniq

Returns per-position occurrence counts where each value increments independently across the array scan.