Ga naar hoofdinhoud

Table.Range

Retourneert de rijen die beginnen bij de opgegeven verschuiving.

Syntax​

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

Remarks​

Retourneert de rijen vanaf de table die beginnen bij de opgegeven offset. Een optionele parameter, count, bepaalt hoeveel rijen er worden geretourneerd. Standaard worden alle rijen na de verschuiving geretourneerd.

Examples​

Example #1​

Alle rijen retourneren vanaf verschuiving 1 in de tabel.

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
)

Result:

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

Example #2​

De ene rij retourneren vanaf verschuiving 1 in de tabel.

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
)

Result:

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

Category​

Table.Row operations