Table.SelectColumns

Table.SelectColumns
Returns a table with only the specified columns.
function (table as table, optional columns as nullable any, optional missingField as nullable any) as table
Description
Returns the table with only the specified columns.    missingField: (Optional) What to do if the columnn does not exist. Example: MissingField.UseNull or MissingField.Ignore.
Category
Table.Column operations
Examples
Only include column [Name].
Table.SelectColumns(Table.FromRecords({
    [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"] ,
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"] ,
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
}), "Name")
Table.FromRecords({ [Name = "Bob"], [Name = "Jim"] , [Name = "Paul"] , [Name = "Ringo"] })
Only include columns [CustomerID] and [Name].
Table.SelectColumns(Table.FromRecords({[CustomerID=1, Name="Bob", Phone = "123-4567"]}), {"CustomerID", "Name"})
Table.FromRecords({[CustomerID=1, Name="Bob"]})
If the included column does not exit, the default result is an error.
Table.SelectColumns(Table.FromRecords({[CustomerID=1, Name="Bob", Phone = "123-4567"]}), "NewColumn")
[Expression.Error] The field 'NewColumn' of the record wasn't found.
If the included column does not exit, option MissingField.UseNull creates a column of null values.
Table.SelectColumns(Table.FromRecords({[CustomerID=1, Name = "Bob", Phone = "123-4567" ]}), {"CustomerID", "NewColumn"}, MissingField.UseNull)
Table.FromRecords({[CustomerID=1, NewColumn=null]})

Table.Schema

Table.SelectRows

Last modified 3yr ago

Copy link

On this page

Table.SelectColumns

Description