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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to capture rejected records of lookup file

0683p000009LuWm.png

Hi, I have two files dept (main) and emp (lookup). There are 2 such records in emp file which are not present in dept file. I want to retrieve these 2 records and the join condition is on dno (department no). Please help if anybody knows the solution to this query.

 

Below are the sample records of dept and emp respectively in which I need to retrieve the highlighted records from emp.

0683p000009LuWw.png0683p000009LuQV.png

Labels (2)
20 Replies
Anonymous
Not applicable
Author

Hello,

Could you please see this solution in topic:https://community.talend.com/t5/Design-and-Development/Capture-rejected-records-in-tMap/m-p/35072#M9...?

Let us know if it works for you.

Best regards

Sabrina