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?  

 

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.