MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples

[@ClaudioCP]

Absolutely spectacular, informative, and fun class!

[@excelisfun]

Glad you like it!!!!

[@shaimamustafa1871]

I used to waste a lot of time doing vlookups and match formulas. Can't wait to try these at work! Will forever be grateful to your channel Sir. Keep it going, we're all becoming better at Excel because of you.

[@excelisfun]

Yes!!! I love to hear that : )

[@khalidmajeed2886]

sir i have no words about your classic work.....Inshallah Allah will give u.

[@LeilaGharani]

Thank you for the detailed explanation of join types. Love the visualization with the Venn diagram.

[@excelisfun]

You are welcome for the Join fun and visuals, Teammate : )

[@rvma77]

Two excel power rangers crossing roads!

[@cakirankale]

This function of powerquery is massive with its usefulness. Thank you Mike.

[@excelisfun]

That is for sure : )

[@mansim1955]

Mike G....Godfather of Excel. I am a fan since years and highly recommend his channel to everybody asking me for good learning sources. Wonders me a lot of times how many people do not know him and his channel. This specific class is simply "WOW"! as containing so many tipps. Plus all the downloadable resources! What an awesome workload - thousand thanks for that! As seeing the comment below from Leila - folks, watch her videos! Seriously! Many thanks to both!

[@excelisfun]

Thanks, Man Sim. I am glad to help : )

[@javidelbosque9592]

I came across your channel about 2 weeks ago and I have been a complete fan! Thank you so much for this, your talent for teaching is amazing.

[@excelisfun]

You are so welcome!

[@vrajtalati5300]

Excellent explanation! Didn't even have to watch full video to fully understand the concepts!

[@excelisfun]

Glad the video helps!!!!

[@rajeshbadola4728]

You are incredible man when it comes to explaining the concept.....

[@arifzainal9317]

The explanation on Joins and Merges can't be any clearer than this. Thanks very much, Professor Mike!!

[@excelisfun]

You are welcome for the clarity, Arif!!!!

[@rizkiwisudawan]

I am a Tax Auditor in Indonesia. What you have taught are very helpful for me to audit the taxpayers General Ledger. Thank you sir.

[@excelisfun]

You are welcome, RIZKI!!! Can you tell me more about how you use this to audit the general ledger? That sounds like fun!

[@alpeshshah891]

Fantastic, learnt another level of power query merges that will save me so much time, thank you for sharing your knowledge.

[@excelisfun]

You are welcome!

[@rodrigocustodio1955]

Mike has a natural talent for teaching is extremely skilled yet very humble, the number one contributor for the spread of excel knowledge to the world, Thank you for this pure awesomeness video!

[@excelisfun]

Thanks for the kind words about the excelisfun spread of Excel Knowledge! It is great to be on our Awesome Online Excel team with you, Rodrigo!!!!

[@AVINASHKUMAR-yi4od]

Excellent expectations

[@lalitsharma9417]

Thanks, another great video and great explanation to understand the concept. wishes good Health .

[@excelisfun]

Glad the join fun helped!!!!

[@AtulSharma-gf5vs]

lovely!!! Joins made easy !!! thanks Mike

[@excelisfun]

You are welcome!

[@zhouyinwei2007]

Was always get confused about the inner , outer , left , right , etc , even when study database in the past , this video not only helps recover memories deep in mind , but also with the great samples, makes concept crystal clear and useful, really helps a lot~

[@excelisfun]

Glad this helps. Telling a good story with good visuals can help to make complicated topics, less complicated.

[@ankursharma6157]

Token of Gratitude!

[@excelisfun]

Thank you very much for your token, Ankur!!!! Your donation helps me to keep making videos so we can all learn : ) : )

[@explainexcel]

Great tutorial. Great handouts. Excellent resources. A lot of work has gone into this video. Everyone should be giving it a thumbs UP. Thank You for sharing.

[@excelisfun]

Glad to help and thank for your support : )

[@liztrama]

I learn more about excel from your videos than from my professor, you are well versed and your instructions are so easy to understand, plus you make learning fun. Thank you!!!

[@GeertDelmulle]

Comprehensive and impressive! This class is history in the making and we're all sitting in the front row...

[@excelisfun]

I am trying to make the definitive Introduction to Microsoft's Power Tools - so hopefully it will be fun and informative : ) Thanks for your kind words, Geert!!!!

[@apa4203]

Hi Mike, I just watched your video with great interesst :)

[@MalinaC]

Another topic every Excel user has to know sooner or later. Thanks Mike for this valuable video!

[@excelisfun]

You are welcome, Malina! Thanks for the support : )

[@MalinaC]

:)

[@petermyran4986]

Grateful for more good PQ learning! And delighted by the excellent review of joins for this old SQL guy.

[@excelisfun]

You know, I meant to slip one example of SQL Join code in just for fun, but then I forgot because it took me so long to create everything.... Glad you are enjoying the PQ Fun - so much more to come (I am simultaneously working on the next 8 - 13 videos that are all about Power Query)... Thanks for your support, Peter, on each video that you watch : )

[@shubhampawar8506]

Getting deeper and deeper in data analysis ...all sorts of merge through visualization of Venn diagram....it's simply amazing and easy to understand ...thanks a lot ❤️

[@excelisfun]

Yes, the visuals in this video and many others in this class are necessary to help make the complicated less complicated.

[@mokhan7623]

I have just started using Power Query after watching some of your amazingly professional videos. I've managed to create a pivot table analysing monthly income and expenses from a query, which includes a few calculated columns, that cleans my downloaded csv bank statements. So now every month I just drop the downloaded file into the target folder, refresh all and viola the pivot table is updated! I've even managed to utilise the data model! Thank you for your truly inspirational teaching and long may you continue!

[@excelisfun]

You are welcome, Mo Khan!!! Thanks for the support with your comment, Thumbs Up and your Sub : )

[@ak.7274]

Thank you for all your hard work and sharing your knowledge. Definitely the best course on youtube, the pace, the lesson breakdowns, the assignments...well done sir. 👏👏👏

[@excelisfun]

You're very welcome!

[@mazarata73]

Thank you Mike for your remarkable engagement and enthusiasm for details in the explanations. Makes it so tangible.

[@excelisfun]

You are welcome! I am glad that is good for you! Now we just need others who want to really learn the Power Tools to come to excelisfun and learn too : ) Thanks for your support, Giuseppe!!!!

[@ismailismaili0071]

very detailed the one who can't understand excel from your side I guarantee you he will never understand it. thank you so much Mr. Mike I really always appreciate your videos.

[@excelisfun]

You are welcome so much!!! Thanks fro your support, Ismail : )

[@evgeniam8882]

I totally fell for Power Query and all of the things I've learned so far are thanks to you. I didn't even know how to use this tool before your videos. I am so grateful. It makes me think sometimes that the functions in excel are no longer useful after PQ.

[@shoeshines2121]

This was a great video explaining the different types of joins in Power Query; The Venn Diagrams are really helpful for folks trying to grasp this concept for the first time. Thank you for the video!

[@timmytesla9655]

Another great video. Thank you!

[@மின்விரிதாள்_விரிப்போம்_வாங்க]

Wonderful series. Since I have known about SQL and joins, it is easy to understand. Thanks.

[@excelisfun]

And now you know joins in both SQL and Power Query!!!

[@suecampanelli311]

Thank you Mike! Catching up on all your MSPTDA tutorials now ( Mar’21)! They are incredibly useful, very well explained!

[@excelisfun]

Glad the videos help, Sue : )

[@rodrigocustodio1955]

Mike your pdf notes are outstanding as all your videos are! This is an epic video indeed. You always have the same enthusiasm and great energy in your delivery, thank you so much for all your support for the Excel community. By the way EPIC VIDEO!

[@excelisfun]

Yes, sometimes the pdf notes are better than the video ...

[@tableaupro3233]

Mike, wonderful video that could server as a very valuable reference along with impeccably detailed PDF notes. Wow! 1. Very nice example data with conference attendees to illustrate join scenarios, especially the non-typical join scenarios 2. Left Outer Join 3 - nice example illustrating the multiplication problem with joins - PQ gives the option to bring all the rows (what I call the multiplication of data on the left side) or to aggregate and then join… this is cool 3. Nice picture of venn diagrams showing 6 join types in PQ 4. Self join example of employee table with referring employee ID is a good example . You could use ManagerID as that is the typical example of storing a hierarchy in a relation DB table structure which brings the case of self-join.

[@excelisfun]

Love the term: "multiplication of data on the left side"! and the example: "storing a hierarchy in a relation DB table structure which brings the case of self-join" Lots more to come in this series, and thank you very much for your awesome support with those comments, Thumbs Up and of course your Sub, Tableau Pro : ) : )

[@Luciano_mp]

Os comentários abaixo só reforçam as minhas convicções, o quanto você é bom, você tem uma didática excelente, você facilita a aprendizagem, e olha que eu não sei inglês, e sim português, você é incrível no excel, uma série fantástica, Power Query é demais.... Tks...Mike... Google Translator: The comments below only reinforce my convictions, how good you are, you have an excellent didactic, you facilitate learning, and look I do not know English, but Portuguese, you are amazing in excel, a fantastic series, Power Query It's too much .... Tks ... Mike ...

[@excelisfun]

Thank you very much, Luciano!!!!! Many More Power Query Videos to come!!!

[@rodrigocustodio1955]

Thank you, Mike, you are an asset for the Excel community. excellent videos !

[@excelisfun]

Thanks for your kind words! I am glad the resources and MSPTDA help you, Rogrigo!!! thanks for your support on each video : )

[@realworldinvesting5631]

By far the best excel videos on KZbin. Wish you had an SQL’s Fun too lol.

[@excelisfun]

Glad the videos help, Real World Investing!!!! Thank you for your support of this free resource I post with your comments, Thumbs Ups and Sub : ) SQL is fun, but I already have an infinite number of topics with Excel and Power Query and DAX, and I can never get around to making SQL videos...

[@villiamo3861]

Excellent: very helpful by being so clearly explained esp with the Venns etc. Thank you!

[@ExceliAdam]

The most thorough movie describing merging in Power Query I've seen 👍

[@excelisfun]

Thanks, Teammate!!! Thanks for your support : )

[@Abdelrahmankali]

Thanks Mike, session is awesome. I am excited that Lookup/Relationships are now replaced with Merged table kinds! It is pretty much getting fun now :) Keep up the great work!

[@excelisfun]

Glad it is fun for you, Abdel!!! Keep going with this series and please help support with those comments and Thumbs Ups and Sub : )

[@luda_c]

Superb tutorials! Their contribution to learning is invaluable. Thank you.

[@excelisfun]

You are welcome for the contributions, Luda! Thank you for your support : )

[@nigelbarrett8973]

Great video as usual - even on subjects I know there is always something new for me to pick up. Concerning Right Anti and Right Outer I find I use them when merging into an already open query.

[@excelisfun]

Me too - I use them as part of a larger multi step Query. Thanks for the comment and support, Nigel!!!!

[@toaipham9051]

Great video!

[@rrrprogram8667]

Every lecture in this channel is gold.... Thanks for making

[@excelisfun]

You are very welcome for the making, RRR!!!! I really appreciate all your support : ) People like you make me want to keep making videos : )

[@williamarthur4801]

This was a lot more interesting than I thought it was going to be ☺

[@khalidmajeed2886]

great great great sir----

[@romanguz]

Again that was amazing! Going through your whole MSPTDA course and loving it! Thank you for being such an inspiration!

[@excelisfun]

You are welcome, Romam : ) : ) Thanks for your support on each video : )

[@ameliewang5771]

Thank you very much for your explicit concept explanation and example. Very helpful!

[@excelisfun]

You are welcome, amelie!!! Thanks for your support with your comment and thumbs up : )

[@msoffice6037]

What a wonderful Excel, what a wonderful Power Query and of course wonderful Mike Girvin!

[@mohamedchakroun4973]

No comment 10/10 Now i am up to date and up to speed with MSPTDA Courses :-)

[@excelisfun]

Awesome! New video coming tomorrow : ) Thanks for your great support, Mohamed : )

[@mohamedchakroun4973]

ExcelIsFun lot of fun and new tricks :-) that what we want :-)

[@kamranb1369]

Was looking forward to this Mike :-) & this is a great video, I was confused about the topic of Joins but our Excel guru just made it easier. You are the best Mike

[@excelisfun]

You are welcome, K B!!! This one took me 7 days and too many hours to get the examples, editing and all else correct - the pdf took longer than the video!?!?!?

[@brianxyz]

I would have guessed that creating the PDF file would have taken a fraction of the time that creating the video did.

[@kamranb1369]

Really appreciate all the effort you put in to help us Mike

[@excelisfun]

It depends on if I create the pdf before the video or after. Which ever one I make first takes the longest because I am constantly editing and revising as I make it to refine and shape the story. For this story I made the pdf first and it took days...

[@excelisfun]

It is fun to do : )

[@hi2832]

You have explained it in such easy way....appreciate that

[@excelisfun]

Easy is good! Thanks for your support, raheel : )

[@bactran7799]

Thank you for the great video. It's super helpful and useful, really clear abt the different kind of joins, easy to understand, help me to get away the confusion of joining data.

[@excelisfun3903]

You are welcome Bac Tran!!! Thank you for the support with your comment, Thumbs Up and Sub : )

[@barttitulaerexcelbart9400]

Thanks Mike. Again a verf goed video form a didactic point of view. One remark if you have discount% and turnover you could make the calculation in PQ. But you can also use a formula in the resulting (green) Excel table. You can totally modify this table in Excel and after an update this structure remains the same: awesome!

[@excelisfun]

Yes indeed it is amazing how flexibale the output green table is : ) Thanks for your support, Bart !!

[@excelisfun]

When you said didactic, did you mean: "in the manner of a teacher, particularly so as to treat someone in a patronizing way."

[@Victor-ol1lo]

Best video on the web with regards to the different join-types.... Cool !!

[@excelisfun]

Thanks, Victor!!!! Hopefully Google Search Engine will know that : )

[@thamgiang7975]

Not only I found your videos super helpful but also I found you are hilarious when trying to find super long short cut keys and that makes me laugh while watching hehe

[@excelisfun]

Laughing is good. Glad you like it, Tham!! Thank you very much for your support with your comment, thumbs up and Sub : )

[@thamgiang7975]

@@excelisfun Hi Sir, Thanks for replying. I'm learning Excel in your channel everyday to improve my Excel skills. I have a quick question that I hope you can help me answer. When I load the data from Power Query to Excel Worksheet, there are often errors together with the number of rows loaded. I don't know why since I follow the exact steps you did in the videos. Is that because my laptop didn't work properly? I hope to hear from you soon. Thank you!

[@excelisfun]

@@thamgiang7975 , There are 1000s of different types of errors. What does the error say? There should always be a yellow area that explains the error.

[@excelisfun]

@@thamgiang7975 Please help the excelisfun channel. If you are learning from these videos everyday, please comment and click thumbs up on every video that you watch, and of course your Sub too : )

[@filipsvakjaroski20]

Excel joins are fun :) Thank you Mike.

[@coccinelleladybird6364]

Excellent, Mike. Thank you for the amazing training.

[@excelisfun]

You are welcome for the training, cossinelle : ) : )

[@marquitosdelacruz8458]

Phenomenally helpful, you are a hero!

[@DIGITAL_COOKING]

It's good from time to time to watch the videos you have always something to get

[@excelisfun]

Glad that is so, DIGITAL COOKING : )

[@ivanrybalchenko7225]

Thank you Mike! Clear explanation, as always!

[@khaledseghari1189]

Great explanation and very useful video. Thank you Mike.

[@excelisfun]

You are welcome, Khaled!!!

[@mohammed333suliman]

Mike, I Don't Know How To Thank You Enough.

[@excelisfun]

Yes you do: Click Thumbs Up every time you watch a video and every time leave a comment. That helps a LOT : ) Also Sub and tell all your friends. That is the way to thank me for posting all this free education. I really appreciate your support : )

[@iamjojo999]

Self join is amazing..

[@excelisfun]

: )

[@nimanitto]

My Friend, you are doing great. even more than great Keep safe man!

[@excelisfun]

Glad to help, Nima!

[@hazemali382]

Back Again to my Favorite channel ♥

[@excelisfun]

Glad that you are boomeranging back, my friend : )

[@hazemali382]

​@@excelisfun your channel I'm not only learn from it but also reference for all followers Mike ♥

[@excelisfun]

@@hazemali382 I am not sure what you mean when you write:" your channel I'm not only learn from it but also reference for all followers Mike"?

[@hazemali382]

​@@excelisfunI mean your channel is the greatest between all Excel channels much Appreciated Mr. Mike ♥

[@excelisfun]

@@hazemali382 Thank you for your kind words : ) I will endeavor to keep making great content for you and the rest of our Team!!!

[@linhgt]

thanks, this topic helps me a lot in comparing two table and looking up without long, painful excel function.

[@871340730]

Thank you so much for the rich content! You are the best!

[@excelisfun]

You are welcome, Shehan!!

[@killerwhales001]

Hii Mike This is Sourabh from India. I am a huge fan of your work and daily watches your videos on KZbin to learn something new. I have decided to watch every playlist in your channel to excel in excel😀 I watched your video on merge in power query, however I stuck in one place. Dataset1 has 87k rows and 12 columns and dataset2 has 37k rows and 42 columns I have left joined the dataset1 with dataset2. When I first did it it gave me a dataset with 227k rows with duplicates. To remove the duplicates I added index column and then expanded the tables from dataset2. Then I removed the duplicates from index column. But now when I try to load the query into a table it takes forever. I have tried many times. This is my work related project. Hope you could help me in identifying the error Many thanks in advance Looking forward to hear from you. Your fan Sourabh

[@walterbierkens]

Your videos are a great find for me, thank you so much! But it really surprises me to see that this video has less than 1000 likes?

[@excelisfun]

Yes, it is sad that for 11 years at KZbin I have posted over 3000 videos with almost every topic in Excel, Array Formulas, Power Query, Power Pivot and more , and many videos that are the definitive source on the internet do not have much support. I have fought for the past 5 years of how to get the content to the people who want it (and it is free), but I have not been able to figure out the marketing trick... : ( BUT, Walter, it is awesome that you support with your comment, thumbs up and Sub. It all starts with viewers like you who managing to get to the video, then learn and have efficient fun!!!! P.S. How did you find this video?

[@mansim1955]

@@excelisfun I wonder each time about the i...s voting thumbs down....None of your videos deserves this.

[@excelisfun]

@@mansim1955 I do not know either. I guess they are confusing rights with obligations? I must say, though, I am thankful for the support from viewers like you : )

[@nattawut_chatwiriyacharoen]

Hi Mike, I love this video, not only techniques but also your visual diagrams. It's so cool. I just know that we can use Left Outer Merge Queries for 2-condition lookup case and multiple match case. It seems like array formula method will be replaced by Power Query soonest. Power Query will be a new era of Excel. Thanks a lots.

[@excelisfun]

But, remember, each tool has its place. There is no doubt that Power Query will replace many complicated Array Formulas, especially for data of any large size, but Formulas have one advantage over Power Query, PivotTables, and so on: Formulas in a spreadsheet update instantly when source data changes, and for some solutions that is a mandatory requirement. For example, for some Accounting or Finance solution where you have formula inputs for what if analysis and you need two lookup value Lookup, I am using formulas, not Power Query. But what is so beautiful about Office 365 Excel is that we have all the tools and we can use them how we want : ) My goal is to try and teach people the newer tools like Power Query, Power Pivot, DAX, TEXTJOIN, MAXIFS ... because most do not use these tools yet. That is why Teammates like you, Nattawut, who post links and share the excelisfun free content with the world are so helpful and actually make the World A Better Place because we are teaching people to become more efficient in what they do : ) : )

[@excelisfun]

Are you Subscribed to exceisfun? I looked at your channel but did not see that you were subbed...

[@nattawut_chatwiriyacharoen]

Totally agree. Each tool has pros and cons, so we have to use the right tool to match requirements. It's my pleasure that you called me "Teammates". I was wondering before why you called Leila and Doug as teammate. Now I understand and am proud that you included me in ^__^ Yes, we have the same goal to introduce new tools like Power Query, Power Pivot, TEXTJOIN and also Power BI to people. These tools are powerful and very helpful. Apart of my facebook fanpage, I also have my blog to share knowledge to Thai people in Thai language. My URL is reportingengineer.com/

[@nattawut_chatwiriyacharoen]

Yes, I have subscribed your channel around 3 years.

[@excelisfun]

O, I looked at your chennel, but I did not see the Sub. Thank you for much for being Subbed and for being an amazing Teammate : )

[@sandip_bettereveryday]

Sir, I would like to add one point in this awesome video. In the Left Outer Join's 3rd Example (at around 30:00), we could have fetched multiple Product's name based on unique Invoice Numbers in a single column separated by comma (or in multiple rows). All we have to do is to add a new Custom Column having the formula: Table.Column([InvoiceLineProductLevel], "Product") Thereafter while 'extracting values' from the resultant LIST, we can mention comma as a separator.

[@excelisfun]

But I thought we were add the numbers, not getting the product names. Are you saying that we could have joined all product names, if we wanted to?

[@sandip_bettereveryday]

ExcelIsFun Yes. Exactly.

[@excelisfun]

Thanks for the cool tip, Sandip!

[@kosalanef]

Thank you very much again for sharing your knowledge... Wonderful explanations...great Video and also great materials.... Thank you for sharing. It is helping so much...

[@excelisfun]

You are welcome, Asantha!!! Thank you very much for your support with your comment, thumbs up and Sub : )

[@excelworx8712]

Power packed! Cant wait to put this to use!

[@excelisfun]

I love this: Power Packed!!!! P.S. I think you are right: Power Query is the most Power Packed tool in Excel : )

[@chrisarguello1170]

The PDF notes absolutely amazing and detailed. 👍

[@excelisfun]

Glad the resources are helpful, Chris!!! Thanks for your support on each vid with your comment, Thumbs Up and of course your Sub : )

[@shoaibrehman9988]

Excellent detail explanations Sir you are gr8 thanks a lot.

[@excelisfun]

You are welcome a lot, Ali!!!

[@ahmedreza3031]

Great video sir..as usual u r awesome...salute. sir..the most imp. thng u share all file which are very helpful for practice...keep it up...great thanks from india...

[@excelisfun]

Yes, I try to share video, files, pdf notes and even homework so you and our other Teammates can learn, have fun and have power! Please help support my efforts with commenst and thumbs Up on every video you learn from - it REALLY helps : )

[@milospavlovic485]

Great video and overall class teaching, keep up with nice work mate...

[@iankr]

Excellent - many thanks.

[@DougHExcel]

Another fantastic video on joins...thanks Mike!

[@excelisfun]

Thanks, Teammate!

[@johnhickton2922]

Your videos are awesome.

[@excelisfun]

I am glad that they help!!!!

[@MuhammadMohsin1985]

Awesome Mike. You are brilliant. Thanks

[@excelisfun]

You are welcome, Muhammad!!!! Thank you for helping me with your support of comment, thumbs up and of course your Sub : )

[@belsergey8096]

Excellent presentation and demonstration. Thanks!

[@excelisfun]

You are welcome, bel!!!! Thank you for the support with your comment, Thumbs Up and Sub : )

[@Mishkafofer]

Another superb video.

[@j4re]

Love your work, keep posting please.

[@excelisfun]

I will keep post if you keep up the support : ) Glad you love it all, JustJust!!!

[@vasilisa6128]

Thank you! Great lesson!

[@harifitfunk1112]

Amazing. The Venn Diagrams made more easy to understand. Just to remind you, I am a newbie to excel still am able to understand. By the end of this playlist-on PowerQuery, I might fall short of the words used to describe your sheer brilliance and simplicity in explanation. ExcelIsFun!!!! Do you have any PowerQuery for the search of such words? ..... :)

[@excelisfun]

I do not have a Power Query query to search for such words. Thank you for the kind words. I am glad that I can help with my visuals and story telling to help make the complicated less complicated. Please help me like I have helped you and any time you watch a video and you learn, leave a comment and a thumbs up, and of course your Sub : )

[@afiqyahya3398]

Where's the video where you import list object? Thank you. I was curious on that. Is it on previous one?

[@nguyeninhty8126]

👏👏👏👏👏👏👏

[@excelisfun]

Thanks for the claps, nguyen!!!

[@Jms0076]

Extremely helpful. Thank you!

[@excelisfun]

You are welcome, Jmsoo76!!

[@sarathchandrakaluarachchi4337]

Thank you very much for informative inputs

[@excelisfun]

You are welcome very much, Sarath!!!

[@karljolivet5991]

So many possibilities. Thank you Mike

[@excelisfun]

So much fun, and you are welcome, Karl!!! Thanks for the support : )

[@andrewjohnson4352]

The start file has more info in it than the video. Can you fix? Thank you for this series. I am loving it!

[@mohitmanwani5298]

Hats Off Mike!!!

[@excelisfun]

Thanks for the hats off, Mohit : )

[@tomr9969]

Great video session on joins and merges! Off to MSPTDA08 ! Thanks again!

[@excelisfun]

You are welcome, Tom R! I appreciate your support. One to the next fun MSPTDA!!!

[@adamshrinah2595]

Thank you

[@excelisfun]

Group fun with video SQRT(49)!!!!!

[@krishnamurthy7721]

Great Great no words.

[@armondnazarian4455]

Clearly explained Thanks!

[@excelisfun]

Glad it was clear, Armond : ) : )

[@iznatsbor]

great explanations and great visualization!