Forum Discussion

Brass Contributor

Jun 13, 2017

Solved

Full Outer Join not working in Version 1707 (Build 8231.1000)

Assume there two tables. One table contains the following: A B C The other table contains the following: D E F A full outer join, after expansion, should create a new table with two colu...

BI & Data Analytics

Need Help

SergeiBaklan
Jun 13, 2017
Hi Stevenson,

That's correct behaviour for Full Outer join, it returns records from both tables with null in other column for not-matching records.

See, for example, http://www.dofactory.com/sql/full-outer-join

SergeiBaklan

Diamond Contributor

Jun 13, 2017

Hi Stevenson,

That's correct behaviour for Full Outer join, it returns records from both tables with null in other column for not-matching records.

See, for example, http://www.dofactory.com/sql/full-outer-join

Stevenson Yu
Brass Contributor
Jun 13, 2017
Thank you for your reply. After more searching, I realized that I was barking up the wrong tree and there was nothing wrong with Full Outer Join. I was confusing it with a Cartesian Join.
- SergeiBaklan
  Diamond Contributor
  Jun 13, 2017
  No problem. Cartesian join is not predefined, if you'd like to have it you may use something like
  
  ... CreateCartesian = Table.AddColumn(stepBefore, "New Column", each Table2), ExpandTable = Table.ExpandTableColumn(CreateCartesian, "New Column", {"Column1"}, {"Column2"}) ...
  other words adding Table2 to each row of Table1