topic tmap update with null value and not equals function in Talend Studio

tmap update with null value and not equals function

Anonymous — Fri, 19 May 2017 14:41:50 GMT

Hello,

I would like to know if it's possible or not to update field with null value in tMap .

I use this :!row1.NOM.equals(row5.NOM) to compare row1(source table) and row2(target table) if I have updated values. It works if I have not null value or empty value but it doesn't work with null or empty value...

Can someone help me how I can figure that with tmap or explain me an other way?

Any help would be really appreciated

Thank you.

Version of Talend :Talend Open Studio for Data IntegrationVersion: 6.3.1

Re: tmap update with null value and not equals function

cterenzi — Fri, 19 May 2017 15:36:40 GMT

You'll have to test for null values before comparing the two values to each other (ex: row1.NOM != null) or else replace null values with empty strings. You can replace nulls using a tMap by changing the output expression for a column from row1.NOM to: row1.NOM == null ? "" : row1.NOM

Re: tmap update with null value and not equals function

Anonymous — Fri, 19 May 2017 15:46:09 GMT

Thank you cterenzi it works !!!

I put "row1.NOM == null ? "" : row1.NOM" in a variable tmap.