📁 Microsoft Excel: Join Types in Power Query
Normalizing a database
Types of Joins with Power Query
The types of operations that can be done through the Power Query tool are
Left Outer Join
A table is created in which all records in the first table X match with the second table Y are inserted. Columns not present in the first table are added from the second table.
If there are multiple items that match in the second table, they are duplicated:
Right Outer Join
A table is created in which all records in the second table X match the first Y are inserted. Columns not present in the first table are added from the second.
Full Outer Join
A table is created in which all the records from both tables are inserted.
Inner Join
A table is created in which all the records present in both tables are inserted.
Left Anti Join
A table is created in which all the records present only in the first table are inserted
Right Anti Join
A table is created in which all the records present only in the second table are inserted