Compare 2 tables

Hello lbendlin ,

Thank you very much for the video with 2 interesting versions,

I've chosen "Inner" instead of "Left Anti" and I'm getting the result I wanted.
Here is the code i used :

let
    Source = Table.NestedJoin(Table_1, {"Code", "Qty"}, Table_2, {"Code", "Qty"}, "Table_2", JoinKind.Inner),
    AntiJoin1 = Table.SelectColumns(Source,{"Code", "date", "Year", "Qty"}),
    #"Added Custom" = Table.AddColumn(AntiJoin1, "Custom", each "Table_1"),
    Custom1 = Table.NestedJoin(Table_2, {"Code", "Qty"}, Table_1, {"Code", "Qty"}, "Table_1", JoinKind.Inner),
    AntiJoin2 = Table.SelectColumns(Custom1,{"Code", "date", "Year", "Qty"}),
    #"Added Custom1" = Table.AddColumn(AntiJoin2, "Custom", each "Table_2"),
    #"Full Anti Join" = Table.Combine({#"Added Custom", #"Added Custom1"}),
    #"Sorted Rows" = Table.Sort(#"Full Anti Join",{{"Code", Order.Ascending}}),
    #"Renamed Columns" = Table.RenameColumns(#"Sorted Rows",{{"Custom", "Source"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Source", type text}})
in
    #"Changed Type"

Have a nice day

Best Regards