One Star

Catching rows that do not match in a tmap lookup

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.
2 REPLIES
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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.