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