Skip to main content

Table.RenameColumns

Applies rename(s) of the form {old, new}.

Syntax​

Table.RenameColumns(
    table as table,
    renames as list,
    optional missingField as MissingField.Type
) as table

Remarks​

Performs the given renames to the columns in table table. A replacement operation renames consists of a list of two values, the old column name and new column name, provided in a list. If the column doesn't exist, an exception is thrown unless the optional parameter missingField specifies an alternative (eg. MissingField.UseNull or MissingField.Ignore).

Examples​

Example #1​

Replace the column name "CustomerNum" with "CustomerID" in the table.

Table.RenameColumns(
    Table.FromRecords({[CustomerNum = 1, Name = "Bob", Phone = "123-4567"]}),
    {"CustomerNum", "CustomerID"}
)

Result:

Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})

Example #2​

Replace the column name "CustomerNum" with "CustomerID" and "PhoneNum" with "Phone" in the table.

Table.RenameColumns(
    Table.FromRecords({[CustomerNum = 1, Name = "Bob", PhoneNum = "123-4567"]}),
    {
        {"CustomerNum", "CustomerID"},
        {"PhoneNum", "Phone"}
    }
)

Result:

Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})

Example #3​

Replace the column name "NewCol" with "NewColumn" in the table, and ignore if the column doesn't exist.

Table.RenameColumns(
    Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
    {"NewCol", "NewColumn"},
    MissingField.Ignore
)

Result:

Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})

Category​

Table.Column operations