how to capture rejected records of lookup file

[Anonymous]

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.

[Anonymous]

Yes @SachinD is correct.

[vidya821]

Hi Sachin,

I am also trying to achieve the same here, but the settings suggested doesnt work for me, could you please have a look settings in tMap and let me know what i am missing here ?
here -
1) row3 file is master/main table
2) row4 file is lookup file and is empty currently

so my outptut out1 should have all records from row3 file

Thanks.
Vidyadhar

capture_rejected_records.png

[TRF]

By definition, "capture rejected inner join" is for inner join and you have a left outer join

[vidya821]

so then, how would i be able to achieve it.

if i set the catch output reject as true, will it help ?

i have tried that setting also but didnt achieve the desired result

[TRF]

If you need an inner join, select "inner join" for the lookup table in the tMap.

[vidya821]

Thanks, it worked

[TRF]

Great!
Don't forget to mark the topic as solved.

[SachinD]

Hi Vidyadhar

Perform 

Join Model  : Inner Join 

out 1 : Inner Join reject : True

As u mentioned your Row 4 / lookup is empty right now, you shall get all rejected rows in  Out 1

Thanks,

Sachin.

[Anonymous]

Hello,

Please stick to one topic so that we can pay individule attention to your issue.

Here is a response for your issue on your another topic:https://community.talend.com/t5/Design-and-Development/Capture-rejected-records-in-tMap/m-p/35072#M9...

Best regards

Sabrina

[Anonymous]

Hello, 

I have same scenario. I have to capture both input rejects in separate output. How I can achieve this?

I have 2 inputs and capture main reject and lookup reject too. 

Help here how to solve such scenario?

Screenshot is attached

sampleSnapshot.JPG
tMapSnapshot.JPG