Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!
You need to be using Append Queries. You can combine multiple tables and it should give you exactly what you want!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |