You are not logged in.
In the area where you're attempting to upper case the string, try the following: <column> == null ? null : StringHandling.UPCASE(<column>). So, if you currently have an expression editor (text box) with the following:
You'd replace it with:
row1.name == null ? null : StringHandling.UPCASE(row1.name)
What this will do is essentially the following:
if row1.name is null
Hope that answers your question.
Windows XP Professional
MS Office 2002
IBM Mainframe DB2
I am trying to copy data from an Excel file to DB2 using tMap and need to convert a field to uppercase. Some of the input fields are null and the UPCASE function throws a NullPointerException. Do you know how to code around this and where to plug the code into Talend? I am using the Java option, even though I don't know Java.