Forum Discussion
How to join two tables together and remove duplicates?
I have two tables that are exactly the same (same column, same data). The difference is how those two tables are being filtered. Because both tables are exactly the same and the only difference is the filtering process, there are some duplicates in them.
I'd like to combine both these tables together (via Opp.Id field) and removing any duplicates. How would you go about doing that?
In short, here's what I'm trying to accomplish:
Table A (original) > Filter 1 > Show data
Table A (duplicate) > Filter 2 > Show data
Based on the filtered data, join both Table A together and remove duplicates.
Screenshot of tables and columns attached.
2 Replies
- Idrissshatila
Super User
Hello stan255tf ,
you should use the append queries in Power query, refer to this for instructions https://learn.microsoft.com/en-us/power-query/append-queries
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hey Idrissshatila, I can't append because both tables have the exact same data. I need both tables to show a different set of data based on how I'm filtering the data.
Here's what I'm trying to accomplish:
Table A1 > Filter 1 > Show data
Table A2 > Filter 2 > Show data
Based on the filtered data, join Table A1 and Table A2 together and remove duplicates.
