Power Query
published
Search
K
Comment on page

Table.AlternateRows

Table.AlternateRows

Keeps the initial offset then alternates taking and skipping the following rows.
function (table as table, offset as number, skip as number, take as number) as table

Description

Keeps the initial offset then alternates taking and skipping the following rows.

Category

Table.Row operations

Examples

Return a table from the table that, starting at the first row, skips 1 value and then keeps 1 value.
Table.AlternateRows(Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"]}), 1, 1, 1)
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=3,Name="Paul",Phone="543-7890"]})