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.



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.


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


Get key values from explicitly defined columns

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

View example input and ouput

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.