Merge issues

Hi Anonymous,

see the sample pbix below which merges the data you provided

sample.pbix 

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!