Bagikan melalui


Table.PositionOfAny

Sintaks

 
Table.PositionOfAny(table as table, rows as list, optional occurrence as nullable number, optional equationCriteria as any) as any

Tentang

Mengembalikan posisi baris dari kemunculan table pertama daftar rows. Mengembalikan -1 jika tidak ada kemunculan yang ditemukan.

  • table: Tabel input.
  • rows: Daftar 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] atau [a = 6, b = 8] dalam tabel ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]}).

Penggunaan

Table.PositionOfAny(
    Table.FromRecords({
        [a = 2, b = 4],
        [a = 1, b = 4],
        [a = 2, b = 4],
        [a = 1, b = 4]
    }),
    {
        [a = 2, b = 4],
        [a = 6, b = 8]
    }
)

Hasil

0

Contoh 2

Temukan posisi semua kemunculan [a = 2, b = 4] atau [a = 6, b = 8] dalam tabel ({[a = 2, b = 4], [a = 6, b = 8], [a = 2, b = 4], [a = 1, b = 4]}.

Penggunaan

Table.PositionOfAny(
    Table.FromRecords({
        [a = 2, b = 4],
        [a = 6, b = 8],
        [a = 2, b = 4],
        [a = 1, b = 4]
    }),
    {
        [a = 2, b = 4],
        [a = 6, b = 8]
    },
    Occurrence.All
)

Hasil

{0, 1, 2}

Kriteria persamaan