Any field that you use code to manipulate needs to do null checks before the manipulation if null values are being passed. Try:
!Relational.ISNULL(fieldName) && fieldName.length() > 0 ? codeToDo :null
The NULL check and empty value verification can be done by above post. There are two specialized components in Talend which can perform Data Quality checks for email and Telephone numbers.
Please utilize them for data quality checks before inserting data to target table. The links for both components are as below.
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema