docs-v2/content/flux/v0.x/stdlib/universe/columns.md

title	description	aliases	menu	weight	flux/v0.x/tags	related	introduced
columns() function	The `columns()` function lists the column labels of input tables. For each input table, it outputs a table with the same group key columns, plus a new column containing the labels of the input table's columns.	/influxdb/v2.0/reference/flux/functions/transformations/columns /influxdb/v2.0/reference/flux/functions/built-in/transformations/columns/ /influxdb/v2.0/reference/flux/stdlib/built-in/transformations/columns/ /influxdb/cloud/reference/flux/stdlib/built-in/transformations/columns/	flux_0_x_ref name parent columns universe	102	transformations metadata	/{{< latest "influxdb" "v1" >}}/query_language/explore-schema/#show-measurements, InfluxQL – SHOW MEASUREMENTS /{{< latest "influxdb" "v1" >}}/query_language/explore-schema/#show-field-keys, InfluxQL – SHOW FIELD KEYS /{{< latest "influxdb" "v1" >}}/query_language/explore-schema/#show-tag-keys, InfluxQL – SHOW TAG KEYS /{{< latest "influxdb" "v1" >}}/query_language/explore-schema/#show-tag-keys, InfluxQL – SHOW SERIES	0.14.0

The columns() function lists the column labels of input tables. For each input table, it outputs a table with the same group key columns, plus a new column containing the labels of the input table's columns. Each row in an output table contains the group key value and the label of one column of the input table. Each output table has the same number of rows as the number of columns of the input table.

columns(column: "_value")

Parameters

column

The name of the output column in which to store the column labels. Defaults to "_value".

tables

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

Examples

{{% flux/sample-example-intro %}}

List all columns per table

import "sampledata"

sampledata.string()
    |> columns(column: "labels")

{{% expand "View input and output" %}} {{< flex >}} {{% flex-content %}}

Input data

{{% flux/sample "string" %}}

{{% /flex-content %}} {{% flex-content %}}

Output data

tag	labels
t1	_time
t1	tag
t1	_value

tag	labels
t2	_time
t2	tag
t2	_value

{{% /flex-content %}} {{< /flex >}} {{% /expand %}}