experimental.set() function

experimental.set() 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.

Function type signature

(<-tables: stream[B], o: A) => stream[C] where A: Record, B: Record, C: Record

Parameters

o

(Required) 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.

tables

Input data. Default is piped-forward data (<-).

Examples

Set values for multiple columns

import "experimental"

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