Current lesson | Lesson 7/10

Right Join, Full Join, and Projections with Power Query in Excel

Excel as a Database (DBMS) – Relationships, Joins, and Data Modeling 0%
Let's complete the Power Query join picture with Right Join and Full Join, and introduce the concept of projection: I'll explain how to select only the columns you need to keep your queries clean and efficient.
Instructor
Up next Many-to-Many Relationships and Junction Tables in Excel