docs-v2/content/flux/v0.x/stdlib/universe/tablefind.md

2.0 KiB

title description aliases menu weight flux/v0.x/tags related introduced
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.
/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/stream-table/tablefind/
/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/stream-table/tablefind/
/influxdb/cloud/reference/flux/stdlib/built-in/transformations/stream-table/tablefind/
flux_0_x_ref
name parent
tableFind universe
102
dynamic queries
/{{< latest "influxdb" >}}/query-data/flux/scalar-values/
0.29.0

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.

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

Parameters

{{% note %}} Make sure fn parameter names match each specified parameter. To learn why, see Match parameter names. {{% /note %}}

fn

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.

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

tables

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

Example

{{% flux/sample-example-intro %}}

import "sampledata"

t = sampledata.int()
    |> tableFind(fn: (key) => key.tag == "t2")

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

{{% note %}} You can use t from the example above as input for getColumn() and getRecord(). {{% /note %}}