https://community.qlik.com/t5/Talend-Studio/NullPointerException-error-with-Nullable-field/m-p/2311502#M82536 <P>Hello,<BR /><FONT size="2"><FONT face="Arial,">I am faced with a 'java.lang.NullPointerException' when I set a null value in a (nullable) field.&nbsp;</FONT></FONT><BR /><FONT size="2"><FONT face="Arial,">The error is just at the t_map, I am not yet inserting in a database</FONT></FONT>.<BR />Here is the transformation I am doing<BR /><BR /></P> <PRE>Relational.ISNULL(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU)) ? null :<BR />"Tim".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 1 :<BR />"Sup".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 0 : null</PRE> <P><BR />When I replace null by 999 there is no error<BR /><BR /></P> <PRE>Relational.ISNULL(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU)) ? 999 :<BR />"Tim".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 1 :<BR />"Sup".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 0 : 999</PRE> <P><BR /><FONT size="2"><FONT face="Arial,">I don't understand why I am getting the error since my fields are nullabe.</FONT></FONT><BR /><BR /><FONT size="2"><FONT face="Arial,">Any help please? Thank you</FONT></FONT><BR /><BR /><BR /><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFWO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145483i1F6DFFE82401203A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFWO.png" alt="0683p000009MFWO.png" /></span></P> Fri, 22 Jul 2016 17:19:27 GMT Anonymous 2016-07-22T17:19:27Z https://community.qlik.com/t5/Talend-Studio/NullPointerException-error-with-Nullable-field/m-p/2311502#M82536 <P>Hello,<BR /><FONT size="2"><FONT face="Arial,">I am faced with a 'java.lang.NullPointerException' when I set a null value in a (nullable) field.&nbsp;</FONT></FONT><BR /><FONT size="2"><FONT face="Arial,">The error is just at the t_map, I am not yet inserting in a database</FONT></FONT>.<BR />Here is the transformation I am doing<BR /><BR /></P> <PRE>Relational.ISNULL(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU)) ? null :<BR />"Tim".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 1 :<BR />"Sup".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 0 : null</PRE> <P><BR />When I replace null by 999 there is no error<BR /><BR /></P> <PRE>Relational.ISNULL(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU)) ? 999 :<BR />"Tim".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 1 :<BR />"Sup".equalsIgnoreCase(StringHandling.TRIM(Stie_adresse.CANDIDAT_STATU))? 0 : 999</PRE> <P><BR /><FONT size="2"><FONT face="Arial,">I don't understand why I am getting the error since my fields are nullabe.</FONT></FONT><BR /><BR /><FONT size="2"><FONT face="Arial,">Any help please? Thank you</FONT></FONT><BR /><BR /><BR /><BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFWO.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/145483i1F6DFFE82401203A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFWO.png" alt="0683p000009MFWO.png" /></span></P> Fri, 22 Jul 2016 17:19:27 GMT https://community.qlik.com/t5/Talend-Studio/NullPointerException-error-with-Nullable-field/m-p/2311502#M82536 Anonymous 2016-07-22T17:19:27Z https://community.qlik.com/t5/Talend-Studio/NullPointerException-error-with-Nullable-field/m-p/2311503#M82537 Have you looked at the line that is throwing the exception in the Code view, to see exactly what is causing the exception? <BR />As you suggest, everything here seems ok Fri, 22 Jul 2016 17:39:16 GMT https://community.qlik.com/t5/Talend-Studio/NullPointerException-error-with-Nullable-field/m-p/2311503#M82537 Anonymous 2016-07-22T17:39:16Z