---
title: Extract scalar values in Flux
description: Use Flux dynamic query 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/cloud/query-data/flux/scalar-values/
estimated_tokens: 1998
product: InfluxDB Cloud (TSM)
version: cloud
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/cloud/query-data/flux/scalar-values/
date: '2025-04-02T15:54:32-06:00'
lastmod: '2025-04-02T15:54:32-06:00'
---

Use Flux [dynamic query functions](/flux/v0/function-types/#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 column from the input stream](#extract-a-column)***or*** [extract a row from the input stream](#extract-a-row).
2. Use the returned array or record to reference scalar values.

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

#### Output scalar values

The InfluxDB `/api/v2/query` HTTP API endpoint and all clients that use it
(InfluxDB UI, `influx` CLI, etc.) only support queries that return a stream of tables.
This endpoint does not support raw scalar output.

To output a scalar value as part of a stream of tables:

1. Import the [`array` package](/flux/v0/stdlib/array/from/).
2. Use [`array.from()`](/flux/v0/stdlib/array/from/) and[`display()`](/flux/v0/stdlib/universe/display/) to wrap the
   literal representation of a scalar value in a stream of tables and return it
   as output.

[](#view-example)

View example

```js
import "array"

SFOTemps =
    sampleData
        |> findColumn(
            fn: (key) => key._field == "temp" and key.location == "sfo",
            column: "_value",
        )

array.from(rows: [{ output: display(v: SFOTemps) }])
```

##### Returns

|          output          |
|--------------------------|
|[ 65.1, 66.2, 66.3, 66.8 ]|

## Table extraction

Flux formats query results as a stream of tables.
Both [`findColumn()`](/flux/v0/stdlib/universe/findcolumn/)and [`findRecord()`](/flux/v0/stdlib/universe/findrecord/)extract the first table in a stream of tables whose [group key](/flux/v0/get-started/data-model/#group-key)values match the `fn` [predicate function](/flux/v0/get-started/syntax-basics/#predicate-functions).

#### Extract the correct table

Flux functions do not guarantee table order.`findColumn()` and `findRecord()` extract only the **first** table that matches the `fn` predicate.
To extract the correct table, use the `fn` predicate function to specifically identify the table to extract or
filter and transform your data to minimize the number of tables piped-forward into the functions.

## Extract a column

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

*See [Sample data](#sample-data) below.*

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

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

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

### 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.

*See [Sample data](#sample-data) below.*

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

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

SFOTemps[0]
// Returns 65.1

SFOTemps[2]
// Returns 66.3

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

## Extract a row

Use the [`findRecord()` function](/flux/v0/stdlib/universe/findrecord/)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
    |> findRecord(
        fn: (key) => key._field == "temp" and key.location == "sfo",
        idx: 0,
    )

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

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

### 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 or bracket notation](/flux/v0/data-types/composite/record/#dot-notation)to reference keys in the record.

```
tempInfo = sampleData
    |> findRecord(
        fn: (key) => key._field == "temp" and key.location == "sfo",
        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

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

## 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
        |> findColumn(fn: (key) => key._field == field, 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

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

##### Extract scalar row data

```
// Define a helper function to extract a row as a record
getRow = (tables=<-, field, idx=0) => {
    extract = tables
        |> findRecord(fn: (key) => true, 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.

```

To return this value from the InfluxDB query API, InfluxDB UI, or influx CLI see[Output scalar values](#output-scalar-values).

## Sample data

The following sample data set represents fictional temperature metrics collected
from three locations.
It’s formatted as an array of Flux [records](/flux/v0/data-types/composite/record/)and structured as a stream of stables using [`array.from()` function](/flux/v0/stdlib/array/from/).

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

```js
import "array"

sampleData =
    array.from(
        rows: [
            {_time: 2019-11-01T12:00:00Z, location: "sfo", _field: "temp", _value: 65.1},
            {_time: 2019-11-01T13:00:00Z, location: "sfo", _field: "temp", _value: 66.2},
            {_time: 2019-11-01T14:00:00Z, location: "sfo", _field: "temp", _value: 66.3},
            {_time: 2019-11-01T15:00:00Z, location: "sfo", _field: "temp", _value: 66.8},
            {_time: 2019-11-01T12:00:00Z, location: "kjfk", _field: "temp", _value: 69.4},
            {_time: 2019-11-01T13:00:00Z, location: "kjfk", _field: "temp", _value: 69.9},
            {_time: 2019-11-01T14:00:00Z, location: "kjfk", _field: "temp", _value: 71.0},
            {_time: 2019-11-01T15:00:00Z, location: "kjfk", _field: "temp", _value: 71.2},
            {_time: 2019-11-01T12:00:00Z, location: "kord", _field: "temp", _value: 46.4},
            {_time: 2019-11-01T13:00:00Z, location: "kord", _field: "temp", _value: 46.3},
            {_time: 2019-11-01T14:00:00Z, location: "kord", _field: "temp", _value: 42.7},
            {_time: 2019-11-01T15:00:00Z, location: "kord", _field: "temp", _value: 38.9},
        ],
    )
    |> group(columns: ["location", "_field"])
```

#### Related

* [Flux dynamic query functions](/flux/v0/function-types/#dynamic-queries)

[scalar](/influxdb/cloud/tags/scalar/)
| output |
| --- |
| output |
| [ 65.1, 66.2, 66.3, 66.8 ] |