Forum Discussion
Merge issues
Hi Anonymous,
see the sample pbix below which merges the data you provided
Steps to reproduce
-> Import both data tables Orders and Shipping
->Click on the table icon left hand side of the header row on the shipping table
--> select Merge Queries
-> Select the Orders Table as the second Table
-> Hold down the shift or ctrl and select the Order | Line No | Product Column as the Join Columns for both Tables
--> Default Left Outer Join should provide what you are looking for
-> Click OK
-> You will see a new column in the shipping table of type table
-> Click the Expand Icon next to the Header Orders
-> Only Select the Promo Column and uncheck the Use Original Column as prefix option
-> Click OK
And you're done
Hope this helps
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
Hi Anonymous,
see the sample pbix below which merges the data you provided
Steps to reproduce
-> Import both data tables Orders and Shipping
->Click on the table icon left hand side of the header row on the shipping table
--> select Merge Queries
-> Select the Orders Table as the second Table
-> Hold down the shift or ctrl and select the Order | Line No | Product Column as the Join Columns for both Tables
--> Default Left Outer Join should provide what you are looking for
-> Click OK
-> You will see a new column in the shipping table of type table
-> Click the Expand Icon next to the Header Orders
-> Only Select the Promo Column and uncheck the Use Original Column as prefix option
-> Click OK
And you're done
Hope this helps
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
BA_Pete amitchandak richbenmintz All - Thank you for the help. In the end, Rich was able to use my recreated example to show me just how simple this actually was. Although the data I gave him was very clean (no trimming, de-dupe, etc needed), it was evident right away what I was doing wrong.
I was not paying attention to the which table I put first (or "left"). I was putting my Order table first, not my Shipments table, and that seemed to be the cause of my issues. I have since successfully "merged" two additional columns from my Orders table to my Shipments table with perfect results!
THANK YOU!