Compare String using tMap

talend
Ahmed BEN MANSOUR picture Ahmed BEN MANSOUR · Nov 17, 2016 · Viewed 7.7k times · Source

I am using Talend to prepare dataware. I want to compare the string with the contents of a column using the tMap component and create a variable to store in the DB. The problem is that the == operator does not give the right result (Example: row2.recipient == "text"?"text":"" I always get "") and if I use .equals I get errors when executing.

Answer

Corentin picture Corentin · Nov 17, 2016

You will get error if row2.recipient is null, and "==" should not be used when comparing strings. Correct syntax would be :

"text".equals(row2.recipient)?"text":""

Then you will prevent NullPointerExceptions.

Related questions

Insert throws SQLCODE: -180, SQLSTATE: 22007 on IBM DB2

I'm using a data integration tool (Talend) to insert some rows on a IBM Db2, but the following command throws an error: INSERT INTO "TOTCHQ" ("CODREM","NUMDOCC8","NOMPES","NUMBAN","CODAGEBN","QTDCHQDL","DATULTOA") VALUES ('3080',99999999999,'FULANO DE TAL',100,'0000',2,…

Read More
How to add third party libraries to Talend project?

How to add third party libraries (jar files) to a Talend project ? One more question is, Each Talend component uses LogFactory, but in my case it is throwing java.lang.NoClassDefFoundError: org.apache.commons.logging.LogFactory at ... with tSetGlobalVar component, …

Read More
Need to Get the current DateTime in the Talend Studio?

I am working the Talend studio tool for data migration. Now I want to set the Current DateTime in the Date field. I get the DateTime from this code TalendDate.getDate("yyyy-MM-dd HH:mm:ss") but it returns String type …

Read More