Help - Blending two data sets (full outer join)

Hi Anonymous 

I build two tables and use Merge and append in Power Query Editor to have a test.

TableA:

TableB:

You can build a new query in Power Query Editor and use this M query:

= let

    Source = Table.NestedJoin(A, {"PRO"}, B, {"PRO"}, "B ", JoinKind.FullOuter),

    #"Expanded B " = Table.ExpandTableColumn(Source, "B ", {"PRO", "Cost", "User"}, {"B.PRO", "B.Cost", "B.User"}),

    #"Filtered Rows" = Table.SelectRows(#"Expanded B ", each [PRO] = null or [B.PRO] = null)

in

    #"Filtered Rows"

Or you can achieve your goal step by step:

1.     Merge TableA and TableB(Full Outer)

2.     Expand B in merge table:

3.     Filter Merge table by each [PRO] = null or [B.PRO] = null

= Table.SelectRows(#"Expanded B", each [PRO] = null or [B.PRO] = null)

Result:

You can download the pbix file from this link: Help - Blending two data sets (full outer join)

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.