---
title: findColumn() function
description: findColumn() returns an array of values in a specified column from the first table in a stream of tables that matches the specified predicate function.
url: https://docs.influxdata.com/flux/v0/stdlib/universe/findcolumn/
estimated_tokens: 310
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/stdlib/universe/findcolumn/
date: '2024-04-08T16:01:02-06:00'
lastmod: '2024-04-08T16:01:02-06:00'
---

* Flux 0.68.0+

InfluxDB support

`findColumn()` returns an array of values in a specified column from the first
table in a stream of tables that matches the specified predicate function.

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 signature

```js
(<-tables: stream[B], column: string, fn: (key: A) => bool) => [C] where A: Record, B: Record
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### column

(Required)
Column to extract.

### fn

(Required)
Predicate function to evaluate input table group keys.

`findColumn()` uses the first table that resolves as `true`.
The predicate function requires a `key` argument that represents each input
table’s group key as a record.

### tables

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

## Examples

### Extract a column as an array

```
import "sampledata"

sampledata.int()
    |> findColumn(fn: (key) => key.tag == "t1", column: "_value")// Returns [-2, 10, 7, 17, 15, 4]

```

#### Related

* [Extract scalar values in Flux](/influxdb/v2/query-data/flux/scalar-values/)

[dynamic queries](/flux/v0/tags/dynamic-queries/)