From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Merge and append queries

Merge and append queries - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Merge and append queries

“

- [Instructor] In this sub lesson, we are going to look at merging and append queries. Generally use an append whenever you want to combine rows of two similar tables into a single table. As a general rule with append, you generally get more rows, but not necessarily more columns, although it is possible and we'll show you that with some examples later. Merged is used when we want to combine columns with two related tables into one table. It is like a join in SQL or a VLOOKUP over in Excel. So what this looks like with an animation here, let's take these two queries. Query one and query two. You'll see they both have three columns each A, B, and C Query. One has three rows, query two has four rows. We go ahead and run append on this. We're simply going to end up with seven rows in query number one. In this case here we have query one and query number two. And if we append these, we can see that query one has columns A, B, and C. And query two has A, B and X. So each one of the queries…

Contents