Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.RemoveColumns

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table without a specific column or columns.

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

Arguments

ArgumentDescription
tableThe Table to modify.
columnsA 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 missingFieldThe 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")  
CustomerIDName
1Bob
© 2018 Microsoft