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]})