Table.RemoveFirstN

Sintaxis

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

Acerca de

Devuelve una tabla que no contiene el primer número especificado de filas, countOrCondition, de la tabla table. El número de filas quitadas depende del parámetro countOrConditionopcional .

• Si countOrCondition se omite solo se quita la primera fila.
• Si countOrCondition es un número, se quitarán muchas filas (comenzando en la parte superior).
• Si countOrCondition es una condición, las filas que cumplen la condición se quitarán hasta que una fila no cumpla la condición.

Ejemplo 1

Quite la primera fila de la tabla.

Uso

Table.RemoveFirstN(
    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
)

Salida

Table.FromRecords({
    [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
})

Ejemplo 2

Quite las dos primeras filas de la tabla.

Uso

Table.RemoveFirstN(
    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
)

Salida

Table.FromRecords({
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
})

Ejemplo 3

Quite las primeras filas donde [CustomerID] <=2 de la tabla.

Uso

Table.RemoveFirstN(
    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"]
    }), 
    each [CustomerID] <= 2
)

Salida

Table.FromRecords({
    [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
    [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
})