Table.MatchesAnyRows

Syntax

Table.MatchesAnyRows(table as table, condition as function) as logical 

About

指示中 table 是否有行与给定 condition的行匹配。 返回 true 任何行是否匹配， false 否则返回。

示例 1

确定列 [a] 中的任何行值是否在表中 ({[a = 2, b = 4], [a = 6, b = 8]})。

用法

Table.MatchesAnyRows(
    Table.FromRecords({
        [a = 1, b = 4],
        [a = 3, b = 8]
    }),
    each Number.Mod([a], 2) = 0
)

输出

false

示例 2

确定表中 ({[a = 1, b = 2], [a = 3, b = 4]})任何行值是否为 [a = 1， b = 2]。

用法

Table.MatchesAnyRows(
    Table.FromRecords({
        [a = 1, b = 2],
        [a = -3, b = 4]
    }),
    each _ = [a = 1, b = 2]
)

输出

true