Table.Range

Syntaxis

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

Over

Retourneert de rijen uit de table beginnend bij de opgegeven offset. Een optionele parameter, count, geeft aan hoeveel rijen moeten worden geretourneerd. Standaard worden alle rijen na de offset geretourneerd.

Voorbeeld 1

Retourneer alle rijen beginnend vanaf offset 1 in de tabel.

Gebruik

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
)

uitvoer

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

Voorbeeld 2

Retourneer één rij vanaf offset 1 in de tabel.

Gebruik

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
)

uitvoer

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