Power Query #7: Merge Join Feature: All Seven Examples
From excelisfun · · 21 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery07Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ This video teaches how to use the 7 types of Joins when you use Merge feature Power Query. Many easy to understand examples. Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:23) Download files so you can practice 4. (00:32) Defined the 7 types of Merge Joins in Power Query 5. (03:16) Accessing Merge Join in Excel and Power BI Desktop 6. (03:26) Files for Power BI example 7. (03:44) MUST use Queries NOT Excel Tables 8. (04:25) Left-Outer Join to lookup a product price 9. (05:37) Left-Outer Join to do a two-value lookup 10. (06:36) Table.NestedJoin Function 11. (07:28) Left-Outer Join to use one lookup value to return multiple matches 12. (09:22) Join-Aggregate feature for Left-Outer Join 13. (09:49) Why you don’t use Join-Aggregate feature: Query is slow 14. (10:25) Alternative to the Join-Aggregate feature: Query is MUCH faster 15. (12:43) Right-Outer Join to join supplier and product tables 16. (14:06) Left-Anti Join to return items in left table that are NOT in right table 17. (15:50) Right-Anti Join to return items in right table that are NOT in left table 18. (17:00) Inner-Join as an AND Logical Test to return items in both tables 19. (17:51) Full-Outer as an OR Logical Test to return all records in both tables 20. (19:23) Self-Join to lookup employee name who referring new employee 21. (20:49) Video Summary and Conclusions 22. (21:23) Mike Girvin’s Power Query M Code book 23. (21:32) Closing and Video Links
This video has subtitles or audio translations in these 109 languages: Abkhazian, Afrikaans, Albanian, Amharic, Arabic, Armenian, Azerbaijani, Bambara, Bangla, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Cantonese (Hong Kong), Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Germany), Greek, Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Khmer, Korean, Kurdish, Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malayalam, Maltese, Mongolian, Nepali, Norwegian, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Punjabi, Russian, Samoan, Sanskrit, Santali, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Sindhi, Sinhala, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil, Tatar, Telugu, Thai, Tibetan, Turkish, Turkmen, Ukrainian, Urdu, Uyghur, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling, #join #joinoperator #merge #powerqueryjoin #combine #datamodel #datascience
View Power Query Video pdf notes: https://excelisfun.net/files/PowerQuery-07.pdf