Skip to content

distinct

Creates a sorted list without duplicates of non-null grouped values.

distinct(xs:list) -> list

The distinct function returns a sorted list containing unique, non-null values in xs.

The values to deduplicate.

from {x: 1}, {x: 2}, {x: 2}, {x: 3}
summarize unique=distinct(x)
{unique: [1, 2, 3]}

collect, count_distinct