---
title: Extract scalar values in Flux
description: Use Flux stream and table functions to extract scalar values from Flux query output. This lets you, for example, dynamically set variables using query results.
url: https://docs.influxdata.com/influxdb/v1/flux/guides/scalar-values/
estimated_tokens: 1755
product: InfluxDB OSS v1
version: v1
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/v1/flux/guides/scalar-values/
date: '2025-08-24T21:29:26-05:00'
lastmod: '2025-08-24T21:29:26-05:00'
---

This page documents an earlier version of InfluxDB OSS.[InfluxDB 3 Core](/influxdb3/core/) is the latest stable version.

Use Flux [dynamic queiry functions](/flux/v0/flux-functions#dynamic-queries)to extract scalar values from Flux query output.
This lets you, for example, dynamically set variables using query results.

**To extract scalar values from output:**

1. [Extract a table](#extract-a-table).
2. [Extract a column from the table](#extract-a-column-from-the-table)***or*** [extract a row from the table](#extract-a-row-from-the-table).

*The samples on this page use the [sample data provided below](#sample-data).*

#### Current limitations

* The InfluxDB user interface (UI) does not currently support raw scalar output.
  Use [`map()`](/flux/v0/stdlib/universe/map/) to add
  scalar values to output data.
* The [Flux REPL](/influxdb/v1/flux/guides/execute-queries/#influx-cli) does not currently support
  Flux stream and table functions (also known as “dynamic queries”).
  See [#15321](https://github.com/influxdata/influxdb/issues/15231).

## Extract a table

Flux formats query results as a stream of tables.
To extract a scalar value from a stream of tables, you must first extract a single table.

to extract a single table from the stream of tables.

> [!Note]
> If query results include only one table, it is still formatted as a stream of tables.
> You still must extract that table from the stream.

Use [`tableFind()`](/flux/v0/stdlib/universe/tablefind/)to extract the **first** table whose [group key](/influxdb/v1/flux/get-started/#group-keys)values match the `fn` **predicate function**.
The predicate function requires a `key` record, which represents the group key of
each table.

```js
sampleData
  |> tableFind(fn: (key) =>
      key._field == "temp" and
      key.location == "sfo"
  )
```

The example above returns a single table:

|       \_time       |location|\_field|\_value|
|--------------------|--------|-------|-------|
|2019-11-01T12:00:00Z|  sfo   | temp  | 65.1  |
|2019-11-01T13:00:00Z|  sfo   | temp  | 66.2  |
|2019-11-01T14:00:00Z|  sfo   | temp  | 66.3  |
|2019-11-01T15:00:00Z|  sfo   | temp  | 66.8  |

#### Extract the correct table

Flux functions do not guarantee table order and `tableFind()` returns only the**first** table that matches the `fn` predicate.
To extract the table that includes the data you actually want, be very specific in
your predicate function or filter and transform your data to minimize the number
of tables piped-forward into `tableFind()`.

## Extract a column from the table

Use the [`getColumn()` function](/flux/v0/stdlib/universe/getcolumn/)to output an array of values from a specific column in the extracted table.

```
sampleData
  |> tableFind(fn: (key) =>
      key._field == "temp"  and
      key.location == "sfo"
  )
  |> getColumn(column: "_value")

// Returns [65.1, 66.2, 66.3, 66.8]

```

### Use extracted column values

Use a variable to store the array of values.
In the example below, `SFOTemps` represents the array of values.
Reference a specific index (integer starting from `0`) in the array to return the
value at that index.

```
SFOTemps = sampleData
  |> tableFind(fn: (key) =>
      key._field == "temp" and
      key.location == "sfo"
  )
  |> getColumn(column: "_value")

SFOTemps
// Returns [65.1, 66.2, 66.3, 66.8]

SFOTemps[0]
// Returns 65.1

SFOTemps[2]
// Returns 66.3

```

## Extract a row from the table

Use the [`getRecord()` function](/flux/v0/stdlib/universe/getrecord/)to output data from a single row in the extracted table.
Specify the index of the row to output using the `idx` parameter.
The function outputs a record with key-value pairs for each column.

```
sampleData
  |> tableFind(fn: (key) =>
      key._field == "temp" and
      key.location == "sfo"
  )
  |> getRecord(idx: 0)

// Returns {
//   _time:2019-11-11T12:00:00Z,
//   _field:"temp",
//   location:"sfo",
//   _value: 65.1
// }

```

### Use an extracted row record

Use a variable to store the extracted row record.
In the example below, `tempInfo` represents the extracted row.
Use [dot notation](/influxdb/v1/flux/get-started/syntax-basics/#records) to reference
keys in the record.

```
tempInfo = sampleData
  |> tableFind(fn: (key) =>
      key._field == "temp" and
      key.location == "sfo"
  )
  |> getRecord(idx: 0)

tempInfo
// Returns {
//   _time:2019-11-11T12:00:00Z,
//   _field:"temp",
//   location:"sfo",
//   _value: 65.1
// }

tempInfo._time
// Returns 2019-11-11T12:00:00Z

tempInfo.location
// Returns sfo

```

## Example helper functions

Create custom helper functions to extract scalar values from query output.

##### Extract a scalar field value

```
// Define a helper function to extract field values
getFieldValue = (tables=<-, field) => {
  extract = tables
    |> tableFind(fn: (key) => key._field == field)
    |> getColumn(column: "_value")
  return extract[0]
}

// Use the helper function to define a variable
lastJFKTemp = sampleData
  |> filter(fn: (r) => r.location == "kjfk")
  |> last()
  |> getFieldValue(field: "temp")

lastJFKTemp
// Returns 71.2

```

##### Extract scalar row data

```
// Define a helper function to extract a row as a record
getRow = (tables=<-, field, idx=0) => {
  extract = tables
    |> tableFind(fn: (key) => true)
    |> getRecord(idx: idx)
  return extract
}

// Use the helper function to define a variable
lastReported = sampleData
  |> last()
  |> getRow(field: "temp")

"The last location to report was ${lastReported.location}.
The temperature was ${string(v: lastReported._value)}°F."

// Returns:
// The last location to report was kord.
// The temperature was 38.9°F.

```

## Sample data

The following sample data set represents fictional temperature metrics collected
from three locations.
It’s formatted in [annotated CSV](/influxdb/v2/reference/syntax/annotated-csv/) and imported
into the Flux query using the [`csv.from()` function](/flux/v0/stdlib/csv/from/).

Place the following at the beginning of your query to use the sample data:

```js
import "csv"

sampleData = csv.from(csv: "
#datatype,string,long,dateTime:RFC3339,string,string,double
#group,false,true,false,true,true,false
#default,,,,,,
,result,table,_time,location,_field,_value
,,0,2019-11-01T12:00:00Z,sfo,temp,65.1
,,0,2019-11-01T13:00:00Z,sfo,temp,66.2
,,0,2019-11-01T14:00:00Z,sfo,temp,66.3
,,0,2019-11-01T15:00:00Z,sfo,temp,66.8
,,1,2019-11-01T12:00:00Z,kjfk,temp,69.4
,,1,2019-11-01T13:00:00Z,kjfk,temp,69.9
,,1,2019-11-01T14:00:00Z,kjfk,temp,71.0
,,1,2019-11-01T15:00:00Z,kjfk,temp,71.2
,,2,2019-11-01T12:00:00Z,kord,temp,46.4
,,2,2019-11-01T13:00:00Z,kord,temp,46.3
,,2,2019-11-01T14:00:00Z,kord,temp,42.7
,,2,2019-11-01T15:00:00Z,kord,temp,38.9
")
```

[](#)
| _time | location | _field | _value |
| --- | --- | --- | --- |
| _time | location | _field | _value |
| 2019-11-01T12:00:00Z | sfo | temp | 65.1 |
| 2019-11-01T13:00:00Z | sfo | temp | 66.2 |
| 2019-11-01T14:00:00Z | sfo | temp | 66.3 |
| 2019-11-01T15:00:00Z | sfo | temp | 66.8 |