Is this merge possible in PQ?

[danhendo888]

Hey folks,
Suppose I create two queries for the two tables in my spreadsheet
https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI

Is it possible to somehow merge them as per my example?

 

[sandy666]

if the names in two tables are different names you'll get empty table as result

Daniel <> Daniel1

or you can try with Index

[SIZE=1]
// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Index = Table.AddIndexColumn(Source, "Index", 1, 1)
in
    Index

// Table2
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Sales", Int64.Type}, {"Date", type date}, {"Ref", type text}}),
    Index = Table.AddIndexColumn(Type, "Index", 1, 1)
in
    Index

// Merge1
let
    Source = Table.NestedJoin(Table1,{"Index"},Table2,{"Index"},"Table2",JoinKind.LeftOuter),
    ExpandT2 = Table.ExpandTableColumn(Source, "Table2", {"Name", "Sales", "Date", "Ref"}, {"Name.1", "Sales", "Date", "Ref"}),
    ROC = Table.SelectColumns(ExpandT2,{"Name", "Sales", "Date", "Ref"})
in
    ROC[/SIZE]

IMO it doesn't make sense