Saltar al contenido principal

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