Table.RemoveLastN
Table.RemoveLastN(table as table, optional countOrCondition as any) as table
返回一个表,该表不包含表 table
中最后的 countOrCondition
行。 删除的行数取决于可选参数 countOrCondition
。
- 如果省略
countOrCondition
,则只删除最后一行。 - 如果
countOrCondition
是数字,则将删除多个行(从底部开始)。 - 如果
countOrCondition
是条件,则将删除满足条件的行,直到出现不满足条件的行为止。
删除表的最后一行。
使用情况
Table.RemoveLastN(
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
)
输出
Table.FromRecords({
[CustomerID = 1, Name = "Bob", Phone = "123-4567"],
[CustomerID = 2, Name = "Jim", Phone = "987-6543"],
[CustomerID = 3, Name = "Paul", Phone = "543-7890"]
})
删除表中 [CustomerID] > 2 的最后几行。
使用情况
Table.RemoveLastN(
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
)
输出
Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})