Power Query Merge without Duplicates

[o59393]

Hi all

I need to merge two tables which have in common the column called 'Site'. 

To the table below called 'Data', I need to add the column called country from the table 'Master Table'

Master table:

After I do the merge I get duplicated values as seen below:

How can I avoid having duplicate countries? In order to have a result like this (by hopefully fixinf the code):

See pbix if needed sample_merge.pbix

Thanks.

[parry2k]

@o59393 do site and plant columns contain unique values? if that is the case then I will do the merge on both Site and Plant and will get the single row.

[DataNinja777]

Hi @o59393 

What about removing duplicates from Remove Rows ribbon in Power Query?  

[DataNinja777]

Hi @o59393 

Since you have Venezuela appearing twice for Product ABC and YZQ, Products information will be lost if you group by ignoring Product.  But you can use Group by to get the result below including also the Product as a group by field.  

[o59393]

Any alternative without removing duplicates?

Thanks.

[Ashish_Mathur]

Hi,

I have not tried this but here's my idea.  We can bring over the Country column from Table 2 as a list.  Then we can remove duplicates for the list.