docs-v2/content/flux/v0.x/stdlib/influxdata/influxdb/schema/fieldsascols.md

title	description	aliases	menu	weight	flux/v0.x/tags	introduced
schema.fieldsAsCols() function	The schema.fieldsAsCols() function pivots a table to automatically align fields within each input table that have the same timestamp.	/influxdb/v2.0/reference/flux/functions/inputs/fromrows /influxdb/v2.0/reference/flux/functions/transformations/influxfieldsascols /influxdb/v2.0/reference/flux/functions/influxdb-v1/fieldsascols/ /influxdb/v2.0/reference/flux/functions/influxdb-schema/fieldsascols/ /influxdb/v2.0/reference/flux/stdlib/influxdb-schema/fieldsascols/ /influxdb/cloud/reference/flux/stdlib/influxdb-schema/fieldsascols/	flux_0_x_ref name parent schema.fieldsAsCols schema	301	transformations	0.88.0

The schema.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.

import "influxdata/influxdb/schema"

schema.fieldsAsCols()

Parameters

tables

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

Examples

import "influxdata/influxdb/schema"

from(bucket:"example-bucket")
    |> range(start: -1h)
    |> filter(fn: (r) => r._measurement == "cpu")
    |> schema.fieldsAsCols()

{{< expand-wrapper >}} {{% expand "View example input and output" %}}

_start and _stop columns have been omitted.

Example input data

_measurement	_host	_time	_field	_value
example	h1	2021-01-01T00:00:00Z	resp_ms	43
example	h1	2021-01-01T00:00:30Z	resp_ms	52
example	h1	2021-01-01T00:01:00Z	resp_ms	30000
example	h1	2021-01-01T00:01:30Z	resp_ms	49

_measurement	_host	_time	_field	_value
example	h1	2021-01-01T00:00:00Z	resp_code	200
example	h1	2021-01-01T00:00:30Z	resp_code	200
example	h1	2021-01-01T00:01:00Z	resp_code	500
example	h1	2021-01-01T00:01:30Z	resp_code	200

Example output data

_measurement	_host	_time	resp_ms	resp_code
example	h1	2021-01-01T00:00:00Z	43	200
example	h1	2021-01-01T00:00:30Z	52	200
example	h1	2021-01-01T00:01:00Z	30000	500
example	h1	2021-01-01T00:01:30Z	49	200

{{% /expand %}} {{< /expand-wrapper >}}