Table.RemoveColumns
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.