Forum Discussion

Matty's avatar
Matty
Icon for Helper II rankHelper II
8 years ago
Solved

How to combine lists and remove duplicates in Power Query...

Hi,

 

I have two lists like as follows:

 

List1
Team1
Team2
Team3
Team4

 

List 2
Team1
Team2
Team5
Team4

 

I want to use Power Query to append the two lists and then remove the duplicates.  This would result in a list like this:

 

All
Team1
Team2
Team3
Team4
Team5

 

Can someone help me with the syntax needed to achieve this?  I'm running into problems because the fields are called different things, so Table.Combine isn't working as desired.

 

Thanks,

 

Matty

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Matty

    For the two lists, select "Append as new", then select "Remove rows"->"Remove duplicates".

     

     

    Best Regards

    Maggie

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Matty

    For the two lists, select "Append as new", then select "Remove rows"->"Remove duplicates".

     

     

    Best Regards

    Maggie

  • Seward12533's avatar
    Seward12533
    Icon for Solution Sage rankSolution Sage
    8 years ago
    Assuming your doing this Power Query. Make a Refence copy of of one of your lists and rename the column headers so they are the same prior to the merge. You can stop the interim query from returning values by combining the queries manually in advanced editor or by right clicking the query and I checking the Load To portion.