Documentation

keyValues() function

keyValues() returns a stream of tables with each input tables’ group key and two columns, _key and _value, that correspond to unique column label and value pairs for each input table.

Function type signature
(<-tables: stream[A], ?keyColumns: [string]) => stream[{B with _value: C, _key: string}] where A: Record, B: Record
For more information, see Function type signatures.

Parameters

keyColumns

List of columns from which values are extracted.

All columns must be of the same type. Each input table must have all of the columns in the keyColumns parameter.

tables

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

Examples

Get key values from explicitly defined columns

data
    |> keyValues(keyColumns: ["sensorID", "_field"])

View example input and output


Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.