unique() function
The unique() function returns all records containing unique values in a specified column.
Group keys, record columns, and values are not modified.
unique() is a selector function.
unique(column: "_value")
Empty tables
unique() drops empty tables.
Parameters
column
Column to search for unique values.
Defaults to "_value".
tables
Input data.
Default is piped-forward data (<-).
Examples
The following example uses data provided by the sampledata package
to show how unique() transforms data.
import "sampledata"
sampledata.int()
|> unique()
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, the following resources are available:
InfluxDB Cloud customers can contact InfluxData Support.