tableFind() function

The tableFind() function extracts the first table in a stream of tables whose group key values match a predicate. If no table is found, the function errors.

Function type: Stream and table

tableFind(fn: (key) => key._field == "fieldName")


Make sure fn parameter names match each specified parameter. To learn why, see Match parameter names.


A predicate function for matching keys in a table’s group key. tableFind returns the first table that resolves as true. Expects a key argument that represents a group key in the input stream.

Data type: Function

Example fn function
(key) => key._field == "fieldName"


t = from(bucket:"example-bucket")
    |> range(start: -5m)
    |> filter(fn:(r) => r._measurement == "cpu")
    |> tableFind(fn: (key) => key._field == "usage_idle")

// t represents the first table in a stream whose group key
// contains "_field" with a value of "usage_idle".

You can use t from the example above as input for getColumn() and getRecord().

Set your InfluxDB URL

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.