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
Sixteen Stars TRF
Sixteen 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

View solution in original post


All Replies
Sixteen Stars TRF
Sixteen 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

View solution in original post

Five Stars

Re: Tmap how to output rejections

Thank you very much that did it. Neil.

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog