experimental.unique() function

experimental.unique() returns all records containing unique values in the _value column.

null is considered a unique value.

Function behavior

• Outputs a single table for each input table.
• Outputs a single record for each unique value in an input table.
• Leaves group keys, columns, and values unmodified.
• 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 rows with unique values in each input table

import "experimental"
import "sampledata"

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