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
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"]})
Last modified 4yr ago