Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.Skip

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a table that does not contain the first row or rows of the table.

Table.Skip(table as table, optional countOrCondition as any) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
optional countOrConditionThe number of rows to skip.

Remarks

  • Table.Skip is similar to List.Skip but requires a table as input.

  • If countOrCondition is a number, that many rows (starting at the top) will be skipped.

  • If countOrCondition is a condition, the rows that meet the condition will be skipped until a row does not meet the condition.

Examples

Table.Skip(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"]  
  
}  
  
), 2)  
CustomerIDNamePhone
3Paul543-7890
4Ringo232-1550
© 2018 Microsoft