任意条件函数匹配
let
表1 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
表2 = Excel.CurrentWorkbook(){[Name="表2"]}[Content],
fun = (a) => Table.SelectRows(Table.AddColumn(表1, "已合并", each Text.Combine({Text.From([姓名], "zh-CN"), Text.From([学籍号], "zh-CN"), Text.From([身份证号], "zh-CN")}, "-"), type text),each Text.Contains([已合并], a))[成绩],
result = Table.AddColumn(表2, "成绩", each try List.Single(fun([查询条件])) otherwise error[检查是否多个匹配])
in
result
