docs-v2/content/flux/v0.x/stdlib/experimental/set.md

title	description	aliases	menu	weight	flux/v0.x/tags	related	introduced
experimental.set() function	The `experimental.set()` function sets multiple static column values on all records.	/influxdb/v2.0/reference/flux/stdlib/experimental/set/ /influxdb/cloud/reference/flux/stdlib/experimental/set/	flux_0_x_ref name parent experimental.set experimental	302	transformations	/flux/v0.x/stdlib/universe/set/	0.40.0

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.

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.

tables

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

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