cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bo_wang5
Helper II
Helper II

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 2021.  However the output of the merge shows (null) for customer 5 and 7.  Is there a way to merge the two tables so I have 2 distinct columns for sales by year and all distinct customers?  Thanks.

 

bo_wang5_0-1631844130572.png

 

 

bo_wang5_2-1631844213260.png

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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.

 

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

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.

 

View solution in original post

Thank you

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors