Comment on page
Table.SelectColumns
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]})
Last modified 5yr ago