Bagikan melalui


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}

Kriteria persamaan