topic Re: How Do I Catch Bad Rows? in Talend Studio

How Do I Catch Bad Rows?

Anonymous — Sat, 16 Nov 2024 06:25:46 GMT

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?

Re: How Do I Catch Bad Rows?

akumar2301 — Tue, 05 Mar 2019 14:06:58 GMT

Try this

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

Re: How Do I Catch Bad Rows?

Anonymous — Tue, 05 Mar 2019 14:27:14 GMT

I tried that and the output gives me a zero

Re: How Do I Catch Bad Rows?

akumar2301 — Tue, 05 Mar 2019 14:40:03 GMT

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

Re: How Do I Catch Bad Rows?

Anonymous — Tue, 05 Mar 2019 14:40:05 GMT

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 🙂

Re: How Do I Catch Bad Rows?

Anonymous — Tue, 05 Mar 2019 16:24:40 GMT

Thank you that helped alot!