Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pawe84
Creator
Creator

Compare two Excel files, remove duplicate in output

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

Labels (2)
1 Reply
manodwhb
Champion II
Champion II

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