experimental.distinct() function

experimental.distinct() returns unique values from the _value column.

The _value of each output record is set to a distinct value in the specified column. null is considered a distinct value.

experimental.distinct() drops all columns not in the group key and drops empty tables.

Function type signature

(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]

Parameters

tables

Input data. Default is piped-forward data (<-).

Examples

Return distinct values from each input table

import "experimental"
import "sampledata"

sampledata.int(includeNull: true)
    |> experimental.distinct()