Returns the rows beginning at the specified offset.
function (
table
as table,offset
as number, optionalcount
as nullable any) as table
Returns the rows from the table
starting at the specified offset
. An optional parameter, count
, specifies how many rows to return. By default, all the rows after the offset are returned.
Table.Row operations
Return all the rows starting at offset 1 in the table.
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)
Table.FromRecords({[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]})
Return one row starting at offset 1 in the table.
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)
Table.FromRecords({[CustomerID=2,Name="Jim",Phone="987-6543"]})