Power Query - Compare two queries and show the new items

[DarkSmile]

Hi,

I'm trying to achieve the following:

I have two tables
export_clist (= new table every week)
Archive (= archive)

I would like to compare export_clist to the archive, all the lanes that are 100% exact match with a lane in archive delete it
result = all the lanes that are shown are new

Export_clist

Archive

This the result should be in a new querie, so final I will have 3 queries, export, archive & new.

Thank you
David

 

[jdellasala]

You would need to merge the two tables. Reading what the Types of Merge are should explain what your results are:

Please use XL2BB when posting data.