Join Types in Power Query

[@anirbandas2626]

Thanks for this great tutorial on joins.. One of the best in youtube for sure.

[@ExcelOlympics]

Uau. Those are very powerful words Anirbas. Thank you! Hope you learned a lot and I'll see you on the next one 😀

[@wayneedmondson1065]

Thanks Gasper! Good to practice and better understand all the join types. Thanks for sharing. Thumbs up!!

[@ExcelOlympics]

True. A great understanding of all the Join types literally means you can do anything when merging queries/steps in Power Query.

[@ExcelWithChris]

Amazing stuff Thanks now I understand them for the first time. Greetings from South Africa.

[@ExcelOlympics]

Great to hear that Chris.

[@roywilson9580]

Nice video, joins are always one of the harder concepts to explain but you made it very clear with a simple example.

[@ExcelOlympics]

Thank you for those kind words Roy. Means a lot!

[@louis439]

Thank you sir, really well explained!

[@ExcelOlympics]

Glad it was helpful Louis!

[@Junmarvi]

Thank you 🙏

[@paulvanobberghen]

I’m sorry to say, and I know English is not your mother language, it’s not mine either, but this is quite painful to follow. YET, THIS _IS_ VERY USEFUL and will probably solve a problem I have. Thanks, and sorry for negative comment.

[@ExcelOlympics]

Hi Paul. Glad to hear you found the content useful.

[@didierc4638]

Thank you Sir Gasper!!! 🎖🎖 very helpfull. Hope I can put il in practice.

[@javidelbosque9592]

Thank you so much for this explanation. Best one I've seen so far about this topic.

[@ExcelOlympics]

Thank you for those kind words Javi. Glad it was helpful!

[@mellarutdyana946]

well sir, how can you make the visualization of valid, error, and empty?

[@ExcelOlympics]

Hi Mella. You go to the View tab of the Power Query editor and select Column Quality and Column Distribution.

[@mellarutdyana946]

Wow you replied my question really fastttt. Million thumbs up for you! Thank you!

[@richardlarkin2705]

Great Job!

[@ExcelOlympics]

Thanks Richard.