Returns a table with only the specified columns.
function (
table
as table, optionalcolumns
as nullable any, optionalmissingField
as nullable any) as table
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
.
Table.Column operations
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]})