Baca dalam bahasa Inggris

Bagikan melalui


Table.ContainsAll

Sintaks

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

Tentang

Menunjukkan apakah semua rekaman yang ditentukan dalam daftar rekaman rows, muncul sebagai baris di table. Parameter equationCriteria opsional dapat ditentukan untuk mengontrol perbandingan antara baris tabel.

Contoh 1

Tentukan apakah tabel berisi semua baris, hanya membandingkan kolom [CustomerID].

Penggunaan

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"
)

Hasil

true

Contoh 2

Tentukan apakah tabel berisi semua baris.

Penggunaan

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"]
    }
)

Hasil

false

Kriteria persamaan