Removes all occurrences of the specified rows from the table.
function (
table
as table,rows
as list, optionalequationCriteria
as nullable any) as table
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.
Table.Membership
Remove any rows where [a = 1] from the table ({[a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]})
.
Table.RemoveMatchingRows(Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4], [a = 1, b = 6]}), {[a = 1]}, "a")
Table.FromRecords({[a = 3, b = 4]}, { "a", "b" })