Pastaba.
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti prisijungti arba pakeisti katalogus.
Prieigai prie šio puslapio reikalingas įgaliojimas. Galite bandyti pakeisti katalogus.
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"]})