Table.RemoveRows

Syntax

Table.RemoveRows(table as table, offset as number, optional count as nullable number) as table

About

Removes count of rows from the beginning of the table, starting at the offset specified. A default count of 1 is used if the count parameter isn't provided.

Example 1

Remove the first row from the table.

Table.RemoveRows(
    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"]
    }),
    0
)
CustomerID Name Phone
2 Jim 987-6543
3 Paul 543-7890
4 Ringo 232-1550

Example 2

Remove the row at position 1 from the table.

Table.RemoveRows(
    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
)
CustomerID Name Phone
1 Bob 123-4567
3 Paul 543-7890
4 Ringo 232-1550

Example 3

Remove two rows starting at position 1 from the table.

Table.RemoveRows(
    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,
    2
)
CustomerID Name Phone
1 Bob 123-4567
4 Ringo 232-1550