Bagikan melalui


Table.ContainsAny

Sintaks

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

Tentang

Menunjukkan apakah ada 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 ({[a = 1, b = 2], [a = 3, b = 4]}) berisi baris [a = 1, b = 2] atau [a = 3, b = 5].

Penggunaan

Table.ContainsAny(
    Table.FromRecords({
        [a = 1, b = 2],
        [a = 3, b = 4]
    }),
    {
        [a = 1, b = 2],
        [a = 3, b = 5]
    }
)

Hasil

true

Contoh 2

Tentukan apakah tabel ({[a = 1, b = 2], [a = 3, b = 4]}) berisi baris [a = 1, b = 3] atau [a = 3, b = 5].

Penggunaan

Table.ContainsAny(
    Table.FromRecords({
        [a = 1, b = 2],
        [a = 3, b = 4]
    }),
    {
        [a = 1, b = 3],
        [a = 3, b = 5]
    }
)

Hasil

false

Contoh 3

Tentukan apakah tabel (Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]})) berisi baris [a = 1, b = 3] atau [a = 3, b = 5] hanya membandingkan kolom [a].

Penggunaan

Table.ContainsAny(
    Table.FromRecords({
        [a = 1, b = 2],
        [a = 3, b = 4]
    }),
    {
        [a = 1, b = 3],
        [a = 3, b = 5]
    },
    "a"
)

Hasil

true

Kriteria persamaan