topic Re: [resolved] Nested If-Else block in Talend Studio

[resolved] Nested If-Else block

Anonymous — Mon, 30 Nov 2015 17:42:04 GMT

Hi All,
I have recently started working on Talend and need some help to implement the below logic :
If (Field1 is null)
{
If (Length(Field2)>0)
   {
      Field2
   }
else
    {"ABC"  }
}
else
{
If (Length(Field3)>0)
   {
      Field3
   }
else
    {"ABC"  }
}
I have used the operators in talend to code this but somehow keep coming up with the null pointer exception. Please help .

Re: [resolved] Nested If-Else block

Anonymous — Mon, 30 Nov 2015 23:57:51 GMT

You can use in-line IFs for this. Something like below....

Field1 == null ? Field2.length()>0 ? Field2 : "ABC" : Field3.length()>0 ? Field3 : "ABC"

Re: [resolved] Nested If-Else block

Anonymous — Tue, 01 Dec 2015 09:34:59 GMT

Tried using the statement below:
OUT2.FIELD1 == null ? (OUT2.FIELD2.length() > 0 ? OUT2.FIELD2 : "OTHER") : (OUT2.FIELD3.length() > 0 ? OUT2.FIELD3 : "OTHER")
But I keep getting a Java exception. Is it an issue with the length() function being used with a Null value coming fro Field2 or Field3 or is there something wrong with the way I'm writing the expression ?

Re: [resolved] Nested If-Else block

Anonymous — Tue, 01 Dec 2015 09:40:10 GMT

It likely is caused by a null Field2. Always check for null before doing any other check. Try this....

OUT2.FIELD1 == null ? ((OUT2.FIELD2!=null && OUT2.FIELD2.length() > 0) ? OUT2.FIELD2 : "OTHER") : ((OUT2.FIELD3!=null && OUT2.FIELD3.length() > 0) ? OUT2.FIELD3 : "OTHER")