project-rename operator
Learn how to use the project-rename operator to rename columns in the output table.
Renames columns in the output table.
Syntax
T | project-rename NewColumnName = ExistingColumnName [, …]
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string | ✔️ | The input tabular data. |
| NewColumnName | string | ✔️ | The new column name. |
| ExistingColumnName | string | ✔️ | The name of the existing column to rename. |
Returns
A table that has the columns in the same order as in an existing table, with columns renamed.
Example
If you have a table with columns a, b, and c, and you want to rename a to new_a and b to new_b while keeping the same order, the query would look like this:
print a='alpha', b='bravo', c='charlie'
| project-rename new_a=a, new_b=b, new_c=c
Output
| new_a | new_b | new_c |
|---|---|---|
| alpha | bravo | charlie |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.