Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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.