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

title	description	menu	weight	flux/v0/tags	introduced
experimental.set() function	`experimental.set()` sets multiple static column values on all records.	flux_v0_ref name parent identifier experimental.set experimental experimental/set	101	transformations	0.40.0

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

{{% caption %}} For more information, see Function type signatures. {{% /caption %}}

Parameters

o

({{< req >}}) 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"})

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

Input data

_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

Output data

_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

{{% /expand %}} {{< /expand-wrapper >}}