Table.ContainsAll

Indica si todos los registros especificados aparecen como filas en la tabla.

Syntax

Table.ContainsAll(
    table as table,
    rows as list,
    optional equationCriteria as any
) as logical

Remarks

Indica si todos los registros especificados en la lista de registros rows aparecen como filas en table. Se puede especificar un parámetro equationCriteria opcional para controlar la comparación entre las filas de la tabla.

Examples

Example #1

Determine si la tabla contiene todas las filas comparando solo la columna [CustomerID].

Table.ContainsAll(
    Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
    }),
    {
        [CustomerID = 1, Name = "Bill"],
        [CustomerID = 2, Name = "Fred"]
    },
    "CustomerID"
)

Result:

true

Example #2

Determinar si la tabla contiene todas las filas.

Table.ContainsAll(
    Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
    }),
    {
        [CustomerID = 1, Name = "Bill"],
        [CustomerID = 2, Name = "Fred"]
    }
)

Result:

false

Category

Table.Membership