Comment on page

Table.Range

Table.Range
Returns the rows beginning at the specified offset.
function (table as table, offset as number, optional count as nullable any) as table
Description
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.
Category
Table.Row operations
Examples
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"]})

Table.PromoteHeaders

Table.RemoveColumns

Last modified 5yr ago