Table.SelectRows |
您所在的位置:网站首页 › row等于m÷b › Table.SelectRows |
Table.SelectRows
项目
09/21/2022
语法
Table.SelectRows(table as table, condition as function) as table
关于
从 table 返回与选择 condition 匹配的行的表。 示例 1选择表中的行,其中 [CustomerID] 列中的值大于 2。 使用情况 Table.SelectRows( 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 = 3, Name = "Paul", Phone = "543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"] }) 示例 2选择表中的名称不包含“B”的行。 使用情况 Table.SelectRows( 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 not Text.Contains([Name], "B") )输出 Table.FromRecords({ [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"], [CustomerID = 4, Name = "Ringo", Phone = "232-1550"] }) |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |