Table.ContainsAny
Table.ContainsAny(table as table, rows as list, optional equationCriteria as any) as logical
Indicates whether any the specified records in the list of records rows
, appear as rows in the table
. An optional parameter equationCriteria
may be specified to control comparison between the rows of the table.
Determine if the table ({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 2]
or [a = 3, b = 5]
.
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 2],
[a = 3, b = 5]
}
)
Output
true
Determine if the table ({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 3]
or [a = 3, b = 5]
.
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
}
)
Output
false
Determine if the table (Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]}))
contains the rows [a = 1, b = 3]
or [a = 3, b = 5]
comparing only the column [a].
Usage
Table.ContainsAny(
Table.FromRecords({
[a = 1, b = 2],
[a = 3, b = 4]
}),
{
[a = 1, b = 3],
[a = 3, b = 5]
},
"a"
)
Output
true