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' ...
Need Help
Show and Tell
DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi @o59393 

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

 

  • 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.