Compare two Excel files, remove duplicate in output

[pawe84]

Hi everyone I have two Excel lists.

In both lists (1 and  2)  are the same product ids.

I need to filter list 2 in order to create a new output file.

This output should only show products which are not already in list 1.

Do I have to use tmap or how to get the result?

Thanks for any hints

[manodwhb]

@pawe84 , you can do with tmap and take the main as a file, which you should have all the duplicate and non-duplicate and other excel as lookup and do inner join and take the inner join rejects, so you will have non-duplicate values.