Table.RenameColumns
Table.RenameColumns(table as table, renames as list, optional missingField as nullable number) as table
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).
Replace the column name "CustomerNum" with "CustomerID" in the table.
Usage
Table.RenameColumns(
Table.FromRecords({[CustomerNum = 1, Name = "Bob", Phone = "123-4567"]}),
{"CustomerNum", "CustomerID"}
)
Output
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})
Replace the column name "CustomerNum" with "CustomerID" and "PhoneNum" with "Phone" in the table.
Usage
Table.RenameColumns(
Table.FromRecords({[CustomerNum = 1, Name = "Bob", PhoneNum = "123-4567"]}),
{
{"CustomerNum", "CustomerID"},
{"PhoneNum", "Phone"}
}
)
Output
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})
Replace the column name "NewCol" with "NewColumn" in the table, and ignore if the column doesn't exist.
Usage
Table.RenameColumns(
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
{"NewCol", "NewColumn"},
MissingField.Ignore
)
Output
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})