InfluxDB Docs

experimental.set() function

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:00Ztemp71.2
2019-09-17T12:00:00Ztemp68.4
2019-09-18T12:00:00Ztemp70.8
Example query
import "experimental"

data
  |> experimental.set(
    o: {
      _field: "temperature",
      unit: "°F",
      location: "San Francisco"
    }
  )
Example output table
_time_field_valueunitlocation
2019-09-16T12:00:00Ztemperature71.2°FSan Francisco
2019-09-17T12:00:00Ztemperature68.4°FSan Francisco
2019-09-18T12:00:00Ztemperature70.8°FSan Francisco