Append 2 tables and remove dublicate rows

[deboec]

Hello guys,

I have two queries in my Excel file via connection.

Both queries are connected to tables with an identical structure (columns).

Only some of the rows are different.

I want to append query 1 with query 2 and only keep the rows which are unique. 
(So not only removce duplicates but also remove all rows that are not unique).

Query 1 and query 2 both have an index column.

[Icey · Accepted solution]

Hi @deboec ,

Try this:

1. Append the two tables.

2. Group the appended table based on your requirements and add a "count" column to count rows at the same time.

3. Only keep the rows which "count"=1.

4. Expand the table.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL]

@deboec , you might want to create a blank query

= Table.Distinct(#"query 1" & #"query 2")

[deboec]

@CNENFRNL 
If I use this sintax the blank query basically only appends the two queries.