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.
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.
Function type: Transformation
columns(column: "_value")
Parameters
column
The name of the output column in which to store the column labels.
Defaults to "_value"
.
Data type: String
Examples
from(bucket: "example-bucket")
|> range(start: -30m)
|> columns(column: "labels")
Get every possible column label in a single table
from(bucket: "example-bucket")
|> range(start: -30m)
|> columns()
|> keep(columns: ["_value"])
|> group()
|> distinct()
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.