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
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.