Forum Discussion
Appending 2 Queries to stack data
Hi There!
My Goal is to stack data from 2 tables that are not related.
My 2 tables are like this
| LAT | LONG | Type |
| 82736 | 23049 | Retail Store |
| 74466 | 23039 | Retail Store |
| 73094 | 27282 | Retail Store |
| LAT | LONG | Type |
| 83684 | 82475 | Dealer |
| 83753 | 84852 | Dealer |
| 83759 | 33823 | Dealer |
How do I get them combined so theyre in 1 Table like this?
| LAT | LONG | Type |
| 83684 | 82475 | Dealer |
| 83753 | 84852 | Dealer |
| 83759 | 33823 | Dealer |
| 82736 | 23049 | Retail Store |
| 74466 | 23039 | Retail Store |
| 73094 | 27282 | Retail Store |
I want to do this so I can MAP everything on 1 layer and color it by Type
Thanks!
Hi Dexter1088 ,
On the query editor select one of the tables and do an append, that will give you the expected result, you then should disable the other table from being loaded.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Regards,
MFelix
1 Reply
Hi Dexter1088 ,
On the query editor select one of the tables and do an append, that will give you the expected result, you then should disable the other table from being loaded.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Regards,
MFelix