function (table
as table,rows
as list, optionalequationCriteria
as nullable any) as logical
rows
, appear as rows in the table
. An optional parameter equationCriteria
may be specified to control comparison between the rows of the table.({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 2]
or [a = 3, b = 5]
.true
({[a = 1, b = 2], [a = 3, b = 4]})
contains the rows [a = 1, b = 3]
or [a = 3, b = 5]
.false
(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].true