v1.fieldsAsCols() function
v1.fieldsAsCols()
was deprecated in Flux v0.88.0 in favor of
schema.fieldsAsCols()
.
The v1.fieldsAsCols()
function is a special application of the
pivot()
function that pivots on _field
and _time
columns to aligns fields within each
input table that have the same timestamp. and resemble InfluxDB 1.x query output.
Function type: Transformation
import "influxdata/influxdb/v1"
v1.fieldsAsCols()
Examples
import "influxdata/influxdb/v1"
from(bucket:"example-bucket")
|> range(start: -1h)
|> filter(fn: (r) => r._measurement == "cpu")
|> v1.fieldsAsCols()
|> keep(columns: ["_time", "cpu", "usage_idle", "usage_user"])
Function definition
package v1
fieldsAsCols = (tables=<-) =>
tables
|> pivot(
rowKey:["_time"],
columnKey: ["_field"],
valueColumn: "_value"
)
Used functions: pivot()
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.