let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"PO", Int64.Type}, {"Number", type any}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Table1[Number]),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From)), type text})
in
#"Extracted Values"
PO | Number | Custom |
12345 | 7891234 | |
45678 | 7891234 |
let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"PO", type text}, {"Number", type any}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Table1[Number]),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From)), type text}),
#"Removed Columns" = Table.RemoveColumns(#"Extracted Values",{"Number"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Custom", "Number"}})
in
#"Renamed Columns"
let
Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"PO", type text}, {"Number", type any}}),
#"Added Custom" = let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"PO", Int64.Type}, {"Number", type any}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Table1[Number]),
#"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Custom", each Text.Combine(List.Transform(_, Text.From)), type text})
in
#"Extracted Values"
in
#"Added Custom"