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 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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for