← Back to Table functions

Table.PrefixColumns

Generates a new table that contains all column names of the provided table with the specified prefix added before each name, followed by a period. The format of the new column names will be prefix.Col...

Syntax

Table.PrefixColumns(table as table, prefix as text) as table

About

Generates a new table that contains all column names of the provided table with the specified prefix added before each name, followed by a period. The format of the new column names will be prefix.ColumnName.

Explanation

Add the prefix "MyTable" to the columns in the table using Power Query M language. This can be achieved by using the MTable.PrefixColumns function and specifying the table along with the desired prefix. The output will be a new table with the columns prefixed with "MyTable" as shown in the example.