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"]})