From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Cross join: Matching everything with everything

Cross join: Matching everything with everything

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Cross join: Matching everything with everything

“

- [Instructor] A cross join is a join that's important for you to know. It can be really handy, but it is not one of the six that are in the Power Query interface. So let me whoop this on ya. Here's the situation, some students came to me said, Oz, we want to be good musicians, and I said, you got to know these four songs, these required songs, and then you'll be a good musician, all right? But, we need to make a check list. We need to match every student with each of the songs so that then we can start measuring their progress. All right? So, we've got our student's query and our song's query, as you can see those on the right side. Now, let's do our cross join. Let's go into the student's query. Edit. Let's boost this up. To do the cross join, I'm going to add a column. Add a custom column, and then the name of that query is what we need. We need the song's query. See that? It's available to us as an…

Contents