Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Renames columns in the output table.
Syntax
T | project-rename NewColumnName = ExistingColumnName [, ...]
Learn more about syntax conventions.
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 |