How Do I Catch Bad Rows?

Highlighted
Five Stars

How Do I Catch Bad Rows?

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?

pic1.pngpic2.png


Accepted Solutions
Employee

Re: How Do I Catch Bad Rows?

Hi,

 

    Please refer the screenshot below.

image.png

 

 

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 :-)

View solution in original post


All Replies
Eleven Stars

Re: How Do I Catch Bad Rows?

Five Stars

Re: How Do I Catch Bad Rows?

I tried that and the output gives me a zero

2019-03-05_0925.png2019-03-05_0924.png

Eleven Stars

Re: How Do I Catch Bad Rows?

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

Regards
Abhishek KUMAR
Employee

Re: How Do I Catch Bad Rows?

Hi,

 

    Please refer the screenshot below.

image.png

 

 

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 :-)

View solution in original post

Five Stars

Re: How Do I Catch Bad Rows?

Thank you that helped alot! Smiley Happy

 

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog