Table.PrefixColumns
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"]})
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for