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: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

This documentation is open source. See a typo? Please, open an issue.


Need help getting up and running? Get Support