Table.RemoveColumns

  • Article

Syntax

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

About

Removes the specified columns from the table provided. If the specified column doesn't exist, an error is raised unless the optional parameter missingField specifies an alternative behavior (for example, MissingField.UseNull or MissingField.Ignore).

Example 1

Remove column [Phone] from the table.

Usage

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

Output

Table.FromRecords({[CustomerID = 1, Name = "Bob"]})

Example 2

Try to remove a non-existent column from the table.

Usage

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

Output

[Expression.Error] The column 'Address' of the table wasn't found.