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.
1
Table.PrefixColumns(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}), "MyTable")