Power Query
published
Search
⌃K

Table.PrefixColumns

Table.PrefixColumns

Returns a table where the columns have all been prefixed with the given text.
function (table as table, prefix as text) as table

Description

Returns a table where all the column names from the table provided are prefixed with the given text, prefix, plus a period in the form prefix.ColumnName.

Category

Table.Column operations

Examples

Prefix the columns with "MyTable" in the table.
Table.PrefixColumns(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}), "MyTable")
Table.FromRecords({[MyTable.CustomerID=1,MyTable.Name="Bob", MyTable.Phone="123-4567"]})