谢谢您的回复。删除t还是不行,同样提示“应为令牌Comma”
let
源1 =Table.UnpivotOtherClumns(Excel.CurrentWorkbook(){[Name="表1"]}[Content], {"住院号","性别","年龄"},"属性","值"),
源2 =Table.UnpivotOtherClumns(Excel.CurrentWorkbook(){[Name="表2"]}[Content], {"住院号","性别","年龄"},"属性","值"),
合并= Table.Distinct((源1&源2),
结果= Table.Pivot(合并,List.Distinct(合并[属性]),,"属性","值")
in
结果 |