findColumn() function

The findColumn() function returns an array of values in a specified column from the first table in a stream of tables where the group key values match the specified predicate. The function returns an empty array if no table is found or if the column label is not present in the set of columns.

Function type: Stream and table

  fn: (key) => key._field == "fieldName",
  column: "_value"



A predicate function for matching keys in a table’s group key. Expects a key argument that represents a group key in the input stream.

Data type: Function


Name of the column to extract.

Data type: String


vs = from(bucket:"example-bucket")
    |> range(start: -5m)
    |> filter(fn:(r) => r._measurement == "cpu")
    |> findColumn(
      fn: (key) => key._field == "usage_idle",
      column: "_value"

// Use column values
x = vs[0] + vs[1]

Select your region

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.