Table.RemoveFirstN

Sintaksis

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

Tentang

Mengembalikan tabel yang tidak berisi jumlah baris pertama yang ditentukan, countOrCondition, dari tabel table. Jumlah baris yang dihapus tergantung pada parameter opsional countOrCondition.

• Jika countOrCondition dihilangkan hanya baris pertama yang dihapus.
• Jika countOrCondition adalah angka, banyak baris tersebut (dimulai dari bagian atas) akan dihapus.
• Jika countOrCondition adalah kondisi, baris yang memenuhi kondisi akan dihapus hingga baris tidak memenuhi kondisi.

Contoh 1

Hapus baris pertama tabel.

Penggunaan

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
)

Output

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

Contoh 2

Hapus dua baris pertama tabel.

Penggunaan

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
)

Output

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

Contoh 3

Hapus baris-baris pertama dari tabel di mana [CustomerID] <= 2.

Penggunaan

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
)

Output

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