Comment on page
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
Keeps the initial offset then alternates taking and skipping the following rows.
Table.Row operations
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"]})
Last modified 5yr ago