Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago

Power Query Merge without Duplicates

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.

Need Help
Show and Tell

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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's avatar
      DataNinja777
      Super User
      2 years ago

      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's avatar
      o59393
      Post Prodigy
      2 years ago

      Any alternative without removing duplicates?


      Thanks.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        2 years ago

        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.