Full Outer Join Merge Join Power Query

preview_player
Показать описание
Published on 16 Oct 2023:

In this video, we will learn to use the full outer join when merging two tables in the power query editor.
The full outer join keeps all records in both the tables we join if a corresponding value does not match, the records from the other table are shown as nulls.

In the previous video, we learnt to use the right outer join when merging two tables in the power query editor.
The right outer join keeps all records in the second table on the join, while keeping only corresponding matching values from the first table.

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!

Our Playists:

ABOUT DAGDOO:
Website:

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License
Рекомендации по теме
Комментарии
Автор

neatly explained, thanks for sharing!

konraddudek