De la cursul: Excel: Power Query (Get & Transform)

Deblocați astăzi cursul complet

Înscrieți-vă astăzi pentru a accesa peste 23.100 de cursuri predate de experți în domeniu.

Overview of joins in Power Query

Overview of joins in Power Query - tutorial Microsoft Excel

De la cursul: Excel: Power Query (Get & Transform)

Începeți evaluarea dvs. gratuită de 1 lună Cumpărați pentru echipa proprie

Overview of joins in Power Query

“

I really want you to get this. We are going to start talking about the merges or joins in Power Query. They can feel advanced, but I know that from Day 1 when I started working with Excel, I had two datasets and I needed to pull data from one dataset over to the other one. It was messy. I could have used VLOOKUP if I had it, but these joins and Power Query would have been so much better because I had to do this over and over again. Now, when the merges showed up in Power Query, they were hard to understand. And that's why I want to go slow through this and help you think about it, because they're named things like outer join, left anti and I'm sitting there thinking and tie what? Left and right of what? I'm going to show you. Just think about it this way. We have two datasets. We have Angus down through Poppy. RSVP for this culinary arts workshop. The other dataset. People who attended the workshop Brit, Carla, et cetera, down to Poppy. Now, we can see Angus is on the RSVP list, but…

Conținut