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.
Syntax
Table.PrefixColumns(table as table, prefix as text) as table
About
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.
Example 1
Prefix the columns with "MyTable" in the table.
Usage
Table.PrefixColumns(
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
"MyTable"
)
Output
Table.FromRecords({[MyTable.CustomerID = 1, MyTable.Name = "Bob", MyTable.Phone = "123-4567"]})