Comment on page

Table.RemoveColumns

Table.RemoveColumns
Removes the specified columns.
function (table as table, optional columns as nullable any, optional missingField as nullable any) as table
Description
Removes the specified columns from the table provided. If the column doesn't exist, an exception is thrown unless the optional parameter missingField specifies an alternative (eg. MissingField.UseNull or MissingField.Ignore).
Category
Table.Column operations
Examples
Remove column [Phone] from the table.
Table.RemoveColumns(Table.FromRecords({[CustomerID=1, Name="Bob", Phone = "123-4567"]}), "Phone")
Table.FromRecords({[CustomerID=1,Name="Bob"]})
Remove column [Address] from the table. Throws an error if it doesn't exist.
Table.RemoveColumns(Table.FromRecords({[CustomerID=1, Name="Bob", Phone = "123-4567"]}), "Address")
[Expression.Error] The field 'Address' of the record was not found.

Table.Range

Table.RemoveFirstN

Last modified 5yr ago