ContextQMD
Back to Influxdb

experimental.unique() function

content/flux/v0/stdlib/experimental/unique.md

latest2.9 KB
Original Source
<!------------------------------------------------------------------------------ IMPORTANT: This page was generated from comments in the Flux source code. Any edits made directly to this page will be overwritten the next time the documentation is generated. To make updates to this documentation, update the function comments above the function definition in the Flux source code: https://github.com/influxdata/flux/blob/master/stdlib/experimental/experimental.flux#L1220-L1220 Contributing to Flux: https://github.com/influxdata/flux#contributing Fluxdoc syntax: https://github.com/influxdata/flux/blob/master/docs/fluxdoc.md ------------------------------------------------------------------------------->

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
js
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

tables

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

Examples

Return rows with unique values in each input table

js
import "experimental"
import "sampledata"

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

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_time_value*tag
2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:10Zt1
2021-01-01T00:00:20Z7t1
2021-01-01T00:00:30Zt1
2021-01-01T00:00:40Zt1
2021-01-01T00:00:50Z4t1
_time_value*tag
2021-01-01T00:00:00Zt2
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:40Zt2
2021-01-01T00:00:50Z1t2

Output data

_time_value*tag
2021-01-01T00:00:00Z-2t1
2021-01-01T00:00:10Zt1
2021-01-01T00:00:20Z7t1
2021-01-01T00:00:50Z4t1
_time_value*tag
2021-01-01T00:00:00Zt2
2021-01-01T00:00:10Z4t2
2021-01-01T00:00:20Z-3t2
2021-01-01T00:00:30Z19t2
2021-01-01T00:00:50Z1t2

{{% /expand %}} {{< /expand-wrapper >}}