content/flux/v0/stdlib/experimental/set.md
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.
(<-tables: stream[B], o: A) => stream[C] where A: Record, B: Record, C: Record
{{% caption %}} For more information, see Function type signatures. {{% /caption %}}
({{< 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.
Input data. Default is piped-forward data (<-).
import "experimental"
data
|> experimental.set(o: {_field: "temperature", unit: "°F", location: "San Francisco"})
{{< expand-wrapper >}} {{% expand "View example input and output" %}}
| _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 |
| _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 >}}