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 a 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.