experimental.unique() function
experimental.unique() is subject to change at any time.
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 emtpy tables.
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]
For more information, see Function type signatures.
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()
Was this page helpful?
Thank you for your feedback!
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, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.