Table.PositionOf
Sintaks
Table.PositionOf(table as table, row as record, optional occurrence as any, optional equationCriteria as any) as any
Tentang
Mengembalikan posisi baris dari kemunculan row
pertama dalam table
yang ditentukan. Mengembalikan -1 jika tidak ada kemunculan yang ditemukan.
-
table
: Tabel input. -
row
: Baris dalam tabel untuk menemukan posisi. -
occurrence
: [Opsional] Menentukan kemunculan baris mana yang akan dikembalikan. -
equationCriteria
: [Opsional] Mengontrol perbandingan antara baris tabel.
Contoh 1
Temukan posisi kemunculan pertama [a = 2, b = 4] dalam tabel ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]})
.
Penggunaan
Table.PositionOf(
Table.FromRecords({
[a = 2, b = 4],
[a = 1, b = 4],
[a = 2, b = 4],
[a = 1, b = 4]
}),
[a = 2, b = 4]
)
Hasil
0
Contoh 2
Temukan posisi kemunculan kedua [a = 2, b = 4] dalam tabel ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]})
.
Penggunaan
Table.PositionOf(
Table.FromRecords({
[a = 2, b = 4],
[a = 1, b = 4],
[a = 2, b = 4],
[a = 1, b = 4]
}),
[a = 2, b = 4],
1
)
Hasil
2
Contoh 3
Temukan posisi semua kemunculan [a = 2, b = 4] dalam tabel ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]})
.
Penggunaan
Table.PositionOf(
Table.FromRecords({
[a = 2, b = 4],
[a = 1, b = 4],
[a = 2, b = 4],
[a = 1, b = 4]
}),
[a = 2, b = 4],
Occurrence.All
)
Hasil
{0, 2}