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 empty tables.
Function type signature
(<-tables: stream[{A with _value: B}]) => stream[{A with _value: B}]

For more information, see Function type signatures.



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


Return rows with unique values in each input table

import "experimental"
import "sampledata" true)
    |> experimental.unique()

View example input and output

Was this page helpful?

Thank you for your feedback!

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more