duplicate() function
The duplicate() function duplicates a specified column in a table.
If the specified column is part of the group key, it will be duplicated, but will
not be part of the output table’s group key.
Function type: Transformation
Output data type: Record
duplicate(column: "column-name", as: "duplicate-name")
Parameters
column
The column to duplicate.
Data type: String
as
The name assigned to the duplicate column.
Data type: String
If the as column already exists, this function will overwrite the existing values.
Examples
from(bucket: "example-bucket")
|> range(start:-5m)
|> filter(fn: (r) => r._measurement == "cpu")
|> duplicate(column: "host", as: "server")
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.