Docs

v2.0

v1.fieldsAsCols() function

The v1.fieldsAsCols() function is a special application of the pivot() function that automatically aligns fields within each input table that have the same timestamp.

Function type: Transformation

import "influxdata/influxdb/v1"

v1.fieldsAsCols()

Examples

import "influxdata/influxdb/v1"

from(bucket:"telegraf/autogen")
  |> range(start: -1h)
  |> filter(fn: (r) => r._measurement == "cpu")
  |> v1.fieldsAsCols()
  |> keep(columns: ["_time", "cpu", "usage_idle", "usage_user"])

Function definition

fieldsAsCols = (tables=<-) =>
  tables
    |> pivot(
      rowKey:["_time"],
      columnKey: ["_field"],
      valueColumn: "_value"
    )

Used functions: pivot()


Bug Reports and Feedback

Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation.

Submit feedback in the InfluxData Community