experimental.set() function

Warning! This page documents an earlier version of Flux, which is no longer actively developed. Flux v0.65 is the most recent stable version of Flux.

The experimental.set() function is subject to change at any time. By using this function, you accept the risks of experimental functions.

The experimental.set() function sets multiple static column values on all records. If a column already exists, the function updates the existing value. If a column does not exist, the function adds it with the specified value.

Once sufficiently vetted, experimental.set() will replace the existing set() function.

Function type: Transformation

The experimental.set() function is subject to change at any time. By using this function, you accept the risks of experimental functions.

import "experimental"

experimental.set(
  o: {column1: "value1", column2: "value2"}
)

Parameters

o

An object that defines the columns and values to set. The key of each key-value pair defines the column name. The value of each key-value pair defines the column value.

Data type: Object

Examples

Set values for multiple columns

Example input table
_time _field _value
2019-09-16T12:00:00Z temp 71.2
2019-09-17T12:00:00Z temp 68.4
2019-09-18T12:00:00Z temp 70.8
Example query
import "experimental"

data
  |> experimental.set(
    o: {
      _field: "temperature",
      unit: "°F",
      location: "San Francisco"
    }
  )
Example output table
_time _field _value unit location
2019-09-16T12:00:00Z temperature 71.2 °F San Francisco
2019-09-17T12:00:00Z temperature 68.4 °F San Francisco
2019-09-18T12:00:00Z temperature 70.8 °F San Francisco