Documentation

set() function

set() assigns a static column value to each row in the input tables.

set() may modify an existing column or add a new column. If the modified column is part of the group key, output tables are regrouped as needed. set() can only set string values.

Function type signature
(<-tables: stream[A], key: string, value: string) => stream[A] where A: Record
For more information, see Function type signatures.

Parameters

key

(Required) Label of the column to modify or set.

value

(Required) String value to set.

tables

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

Examples

Set a column to a specific string value

import "sampledata"

sampledata.int()
    |> set(key: "host", value: "prod1")

View example input and ouput


Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.