Skip to main content

Table.RemoveColumns

Removes the specified columns.

Syntax​

Table.RemoveColumns(
    table as table,
    columns as any,
    optional missingField as MissingField.Type
) as table

Remarks​

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

Examples​

Example #1​

Remove column [Phone] from the table.

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

Result:

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

Example #2​

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

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

Result:

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

Category​

Table.Column operations