How to join two tables together and remove duplicates?

[stan255tf]

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.

[Idrissshatila]

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 👍

Follow me on Linkedin

[stan255tf]

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.