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 th...
Idrissshatila
Super User
Super UserHello 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.