Skip to content

Latest commit

 

History

History
37 lines (27 loc) · 816 Bytes

table-removematchingrows.md

File metadata and controls

37 lines (27 loc) · 816 Bytes
Raw
description title
Learn more about: Table.RemoveMatchingRows
Table.RemoveMatchingRows

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