Table.Skip

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

返回一个表,该表不包含表 table 的指定数量的前几行 countOrCondition。 跳过的行数依赖于可选参数 countOrCondition

  • 如果忽略 countOrCondition,则只跳过第一行。
  • 如果 countOrCondition 为数字,则将跳过该数字那么多的行(从顶部开始)。
  • 如果 countOrCondition 是条件,将跳过满足此条件的行,直到行不满足条件为止。
示例:

跳过表的第一行。

使用情况:

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

示例:

跳过表的前两行。

使用情况:

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

输出:

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

示例:

跳过表中 [Price] > 25 的前几行。

使用情况:

Table.Skip(Table.FromRecords({[OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0], [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0], [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0], [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0], [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0], [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0], [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25], [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0], [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]}), each [Price] > 25)

输出:

Table.FromRecords({[OrderID=2,CustomerID=1,Item="1 lb. worms",Price=5],[OrderID=3,CustomerID=2,Item="Fishing net",Price=25],[OrderID=4,CustomerID=3,Item="Fish tazer",Price=200],[OrderID=5,CustomerID=3,Item="Bandaids",Price=2],[OrderID=6,CustomerID=1,Item="Tackle box",Price=20],[OrderID=7,CustomerID=5,Item="Bait",Price=3.25],[OrderID=8,CustomerID=5,Item="Fishing Rod",Price=100],[OrderID=9,CustomerID=6,Item="Bait",Price=3.25]})

results matching ""

    No results matching ""