topic Re: Compare two Excel files, remove duplicate in output in Talend Studio

Compare two Excel files, remove duplicate in output

pawe84 — Sat, 16 Nov 2024 02:29:52 GMT

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

Re: Compare two Excel files, remove duplicate in output

manodwhb — Fri, 08 May 2020 05:05:05 GMT

@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.