chloe914Frequent Visitor3 years agoFull outer join Hello all. I would like to use the picture from Microsoft as an example. After combine the left and right table, it becomes the merged table below. How can I get the last row CountryID show ...Show More
Jamie-Frequent Visitor3 years agoWhen you do a merge in Power Query you get the option to choose your join kind, here you can choose Full Outer.
chloe914Frequent Visitor to Jamie-3 years agoThanks but full outer can only show as 1st picture but not 2nd picture.
chloe914Frequent Visitor to Jamie-3 years agoThanks but full outer can only show as 1st picture but not 2nd picture.
Related contentFull Outer Join Handling Null Values in common fieldsmerge two table with full outer join valuesFull outer join with three tablesLeft Outer Join through Relation ship joiningDax: Full Outer Join so all rows from both tables are kept
