rename() function
rename() renames columns in a table.
If a column in the group key is renamed, the column name in the group key is updated.
Function type signature
(<-tables: stream[B], ?columns: A, ?fn: (column: string) => string) => stream[C] where A: Record, B: Record, C: Record
For more information, see Function type signatures.
Parameters
columns
Record that maps old column names to new column names.
fn
Function that takes the current column name (column) and returns a
new column name.
tables
Input data. Default is piped-forward data (<-).
Examples
- Explicitly map column names to new column names
- Rename columns using a function
- Conditionally rename columns using a function
Explicitly map column names to new column names
import "sampledata"
sampledata.int()
|> rename(columns: {tag: "uid", _value: "val"})
Rename columns using a function
import "sampledata"
sampledata.int()
|> rename(fn: (column) => "${column}_new")
Conditionally rename columns using a function
import "sampledata"
sampledata.int()
|> rename(
fn: (column) => {
_newColumnName = if column =~ /^_/ then "${column} (Reserved)" else column
return _newColumnName
},
)
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
InfluxDB Cloud customers can contact InfluxData Support.