Table.RemoveMatchingRows
Syntax
Table.RemoveMatchingRows(table as table, rows as list, optional equationCriteria as any) as table
About
Removes all occurrences of the specified rows
from the table
. An optional parameter equationCriteria
may be specified to control the comparison between the rows of the table.
Example 1
Remove any rows where [a = 1] from the table ({[a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]})
.
Usage
Table.RemoveMatchingRows(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4],
[a = 1, b = 6]
}),
{[a = 1]},
"a"
)
Output
Table.FromRecords({[a = 3, b = 4]})
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