Tmap how to output rejections

Five Stars

Tmap how to output rejections

Hello,

 

New to talend and I have three files inputting to my Tmap and I'm getting the expected results. However I am trying to capture rejected rows and output these also. As you can see from my input one has 120 rows the other 335 and I'm getting the 65 rejected outputs I'm expecting however I can't figure out how to catch the rejected rows from the other inputs. As you can see the output row is 0 and despite trying multiple ways I can't figure it out. Is it because my main input file comicfilm is containing the 65 correct output and I can't track the rejects from the other input files? 

 

Any help is much appreciated.

 

Neil.

job.jpgtmap rejections.jpg


Accepted Solutions
Highlighted
Fifteen Stars TRF
Fifteen Stars

Re: Tmap how to output rejections

Define the join between the main row and the lookup as an inner join. Then, set the "Catch lookup inner join reject" option to True.
The "Catch output reject" option you are using is for filter rejection.

TRF

All Replies
Highlighted
Fifteen Stars TRF
Fifteen Stars

Re: Tmap how to output rejections

Define the join between the main row and the lookup as an inner join. Then, set the "Catch lookup inner join reject" option to True.
The "Catch output reject" option you are using is for filter rejection.

TRF
Five Stars

Re: Tmap how to output rejections

Thank you very much that did it. Neil.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download