experimental.unique() function

The experimental.unique() function returns all records containing unique values in the _value column. null is considered a unique value.

Function type: Selector

import "experimental"

experimental.unique()

Output schema

experimental.unique() outputs a single table for each input table and does the following:

• Outputs a single record for each unique value.
• Leaves group keys, columns, and values unmodified.

Parameters

tables

Input data. Default is pipe-forwarded data.

Data type: String

Examples

import "experimental"

data
 |> experimental.unique()