Table.Range

Sintaks

Table.Range(table as table, offset as number, optional count as nullable number) as table

Tentang

Mengembalikan baris dari awal table pada yang ditentukan offset. Parameter opsional, count, menentukan berapa banyak baris yang akan dikembalikan. Secara default, semua baris setelah offset dikembalikan.

Contoh 1

Mengembalikan semua baris mulai dari offset 1 dalam tabel.

Penggunaan

Table.Range(
    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"]
    }),
    1
)

Hasil

Table.FromRecords({
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
})

Contoh 2

Mengembalikan satu baris mulai dari offset 1 dalam tabel.

Penggunaan

Table.Range(
    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"]
    }),
    1,
    1
)

Hasil

Table.FromRecords({[CustomerID = 2, Name = "Jim", Phone = "987-6543"]})