Returns a table where the columns have all been prefixed with the given text.
function (
table
as table,prefix
as text) as table
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
.
Table.Column operations
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"]})