topic Catching rows that do not match in a tmap lookup in Talend Studio

Catching rows that do not match in a tmap lookup

Anonymous — Sat, 16 Nov 2024 13:59:14 GMT

Hi,
I'm relatively new to Talend and have created a mapping which uses a lookup to validate an input field from a database table against another database table via a lookup before outputing the rows.
I cannot seem to find a way to write the record to an error log when the lookup fails.
Can someone please advise on the best/simplest way to achieve this?
Thanks in advance,
Perry.

Re: Catching rows that do not match in a tmap lookup

Anonymous — Tue, 21 Apr 2009 02:59:20 GMT

Hello Perry
As my screenshot shows, do a inner join and get the unmatched rows.

I cannot seem to find a way to write the record to an error log when the lookup fails.

In Talend, we use the tLogCatcher component to manage error info, it will catch the exception and log them into file/DB.
Best regards
shong

Re: Catching rows that do not match in a tmap lookup

Anonymous — Fri, 27 Aug 2010 21:15:23 GMT

This looks like what I would need, but not sure how to implement.
In my situation, I have a number of columns from an old table that are being pulled into the new structure.
The new table has Foreign Key Constraints for some of the values in the incoming fields. Unfortunately, the old data has values that are no longer present in the new system. I want to be able to catch and save all the records where there is an error, but continue on with the rest of the records.
How do I do something like this?
Thanks.