experimental.unpivot() function

experimental.unpivot() creates _field and _value columns pairs using all columns (other than _time) not in the group key. The _field column contains the original column label and the _value column contains the original column value.

The output stream retains the group key and all group key columns of the input stream. _field is added to the output group key.

Function type signature

(<-tables: stream[{A with _time: time}], ?otherColumns: [string]) => stream[{B with _value: C, _field: string}] where A: Record, B: Record

Parameters

tables

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

otherColumns

List of column names that are not in the group key but are also not field columns. Default is ["_time"].

Examples

Unpivot data into _field and _value columns

import "experimental"

data
    |> experimental.unpivot()