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!
Anonymous , Can you share sample data and sample output in table format?
Hope you have already explored
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
amitchandak Hi Amit - Yes, I have indeed watched those...and your's and other's tips have been helpful. But still can't seem to get there.
I think I am at the point where I need to try and put together some "example" data and upload. I have a huge model, with company info in it, so need to spend some time to recreate a simplistic version of the issue that can be shared, which I will do, and upload in this thread.
Anonymous , what you pasted seem like text, not a table. So not able to get much out of it.
amitchandak Attached is a simple file (with two tabs). Goal is to get the Promo field into the shipments table.
https://drive.google.com/file/d/1po5DMFcwQR54CpfmsuyxUKcDtRXwB20j/view?usp=sharing
Note there is one less row on the shipment table than on the order table...normal because we have orders that have not yet shipped.