Merged table (duplicates)

Question

Hello Community:&nbsp;&nbsp;The purpose of trying to merge tables in my case is because I need the Promotion Code column (yellow) to be available to me in another table.&nbsp; &nbsp;It currently resides in the Orders table.....but I need to have it also be in my Shipped table.&nbsp;&nbsp;&nbsp;I created a reference table, deleted all other columns, and just kept the ones below.&nbsp; &nbsp; My intention was to merge this with the Shipped table.&nbsp; &nbsp;&nbsp;&nbsp;No matter what I try, I cannot get the correct amount of rows when the tables are merged.&nbsp; &nbsp; I just simply want the same number of rows...but just really want to add these columns to Promotion Code column to my shipped table.&nbsp; &nbsp;&nbsp;&nbsp;Help please!&nbsp; 🙂&nbsp; &nbsp;&nbsp;

parry2k · Answer

Anonymous&nbsp;better to provide sample data and expected output, it is not very easy to follow what you are trying to do and what is not working.
&nbsp;
&nbsp;

tommartens · Answer

Hey&nbsp;Anonymous&nbsp;,
&nbsp;
it's difficult to provide some guidance or tips, as it's not totally clear (at least to me) what's going on. Please provide some more information, do you have more rows after the merge, is this true for each row in the shipped table, ... Things like that.
&nbsp;
This article explains all the different merge operations:https://radacad.com/choose-the-right-merge-join-type-in-power-bi
&nbsp;
Hopefully, this provides some new ideas on how to tackle your challenge.
&nbsp;
Regards,Tom

amitchandak · Answer

Anonymous , hope you created a list or table. If list, converted to a table. Deleted duplicate and added index and merged 
https://www.youtube.com/watch?v=Zlu99RUtMRY

anonymous · Answer

amitchandak&nbsp;TomMartens&nbsp;parry2k&nbsp;&nbsp;Thanks everyone.&nbsp; &nbsp;Amit that video was helpful but the only issue is that the new query that is created is refernced back to the source file.&nbsp; &nbsp; &nbsp; My issue is like this:&nbsp; &nbsp; I have two tables.&nbsp; &nbsp; A very simplistic view of them is below.&nbsp; &nbsp;The "Promotion Code" field exists on my Orders table, but it does not exist on my Shipments table.&nbsp; &nbsp; I need it to.&nbsp; &nbsp;&nbsp;Table 1&nbsp; (Orders)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table 2&nbsp; (Shipments)Order ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Order IDPromotion Code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXX

amitchandak · Answer

Anonymous&nbsp;, If one order id has only one promo code. I would have that dimension and use. Or I can populate it back shipments. The way is to merge it with shipments in power query. There is a Dax way. But prefer a power query.&nbsp;
&nbsp;
If one order id has more than one promo code, how you want to use it?

Forum Discussion

Merged table (duplicates)

5 Replies

Related content

Table Merge creates duplicate records

Merge queries causing duplicate records

Merge duplicates data in columns

Merge statement creates duplicates - Low shuffle merge as cause?

Merge two tables and avoid duplicates