Baca dalam bahasa Inggris

Bagikan melalui


Table.Contains

Sintaks

Table.Contains(table as table, row as record, optional equationCriteria as any) as logical

Tentang

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

Contoh 1

Tentukan apakah tabel berisi baris.

Penggunaan

Table.Contains(
    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"]
    }),
    [Name = "Bob"]
)

Hasil

true

Contoh 2

Tentukan apakah tabel berisi baris.

Penggunaan

Table.Contains(
    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"]
    }),
    [Name = "Ted"]
)

Hasil

false

Contoh 3

Tentukan apakah tabel berisi baris yang hanya membandingkan kolom [Nama].

Penggunaan

Table.Contains(
    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 = 4, Name = "Bob"],
    "Name"
)

Hasil

true

Kriteria persamaan