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
Forteen Stars TRF
Forteen 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
Forteen Stars TRF
Forteen 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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.