Table.RemoveColumns

About

Returns a table without a specific column or columns.

Syntax

Table.RemoveColumns(table as table, columns as any, optional missingField as nullable number) as table  

Arguments

Argument Description
table The Table to modify.
columns A text value or a list of text values with the names of the columns to remove. missingField is a number value provided to specify handling for missing fields.
optional missingField The default value of missingField is MissingField.Error. For more information, see Parameter Values.

Remarks

  • Table.RemoveColumns is similar to Record.RemoveFields applied to every row in a table.

Examples

Table.RemoveColumns(Table.FromRecords({[CustomerID=1, Name="Bob", Phone = "123-4567"]}), "Phone")  
CustomerID Name
1 Bob