Forum Discussion
Solved
Merge Columns from Multiple Tables
I have a data model with multiple sources. These sources all have the same field names. I'm needing to create a new table that merges certain columns of interest into one. Here is a simplified example of what I mean:
Table1
| color | height | weight |
| blue | 6 ft | 125 lbs |
| green | 1 ft | 600 lbs |
Table2
| color | height | weight |
| yellow | 5 ft | 200 lbs |
| purple | 12 ft | 4 lbs |
Table3
| color | height | weight |
| orange | 7 ft | 3 lbs |
| black | 8 ft | 12 lbs |
New_Table
| color | weight |
| blue | 125 lbs |
| green | 600 lbs |
| yellow | 200 lbs |
| purple | 4 lbs |
| orange | 3 lbs |
| black | 12 lbs |
I've tried using Merge Queries in Power Query Editor, but as far as I can tell this only merges two tables. What I need is to be able to extract columns from multiple tables to show in a combined new table. Is this possible?
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!
1 Reply
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!