Forum Discussion
merging 2 queries with full outer
I'm try to merge 2 queries with sales by customer in differnet years. I tried to turn the merge to "full outer" hoping to capture the customer who didn't have sales in 2020 but did have sales in 202...
In each of the original tables, unpivot the Sales Column. That will bring Sales 2020 and Sales 2021 into a column. Rename the columns Year.
--
You can then Append the 2 tables.
If you want you can leave the table like that or select the Year column and Pivot it.
In each of the original tables, unpivot the Sales Column. That will bring Sales 2020 and Sales 2021 into a column. Rename the columns Year.
--
You can then Append the 2 tables.
If you want you can leave the table like that or select the Year column and Pivot it.
Thank you