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

import "experimental"

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

Parameters

o

A record 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: Record

Examples

Set values for multiple columns

Example input table

Example query

import "experimental"

data
  |> experimental.set(
    o: {
      _field: "temperature",
      unit: "°F",
      location: "San Francisco"
    }
  )

Example output table