experimental.set() function

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.

*Function type: Transformation*

*Data type: Record*

Examples

Set values for multiple columns

Example input table

Example query


data
      _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

set() function

experimental.set