How Do I Catch Bad Rows?

[Anonymous]

Hello all I am some what new to Talend and I have a question.

I have written a job where I am using an Exprexxion filter to get the rows that I need. Which is doing exactly what we want but now the client wants to see the records that are not being passed on. As shown below there is total of 809 and 603 are being passed on but is there a way to get the 206 and place them in a different file.

Is there a way to get these records?

[akumar2301]

Try this 

http://umashanthan.blogspot.com/2015/11/what-difference-between-tmap-catch.html

[Anonymous]

I tried that and the output gives me a zero

[akumar2301]

I hope you already tried Catch Inner Join Rejects as well.

Other method to debug tMap is as below 

https://community.talend.com/t5/How-Tos-and-Best-Practices/How-to-debug-tMap-errors/td-p/40951

[Anonymous · Accepted solution]

Hi,

    Please refer the screenshot below.

You need to add the filter expressions to the main output. Any records which is not matching the main expression will automatically come to the reject flow.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thank you that helped alot!