topic Re: Tmap " exception in thread " Expresison Builder in Talend Studio

Tmap " exception in thread " Expresison Builder

daez — Fri, 30 Nov 2018 10:18:41 GMT

Hello everyone,

I have been struggling on my Expression Builder since yesterday ... I dont understand why my variable isnt working.

My code is :

(row2.code == "A10" || row2.code == "M10")? "R":(( row2.code == "D11" || row2.code == "D12" || row2.code == "M12")
?"T":(( row2.code == "C11" || row2.code == "C12" || row2.code == "C13")
?"C":(( row2.code == "999")?"R":null)))

Where am I wrong ... ?

Re: Tmap " exception in thread " Expresison Builder

manodwhb — Fri, 30 Nov 2018 10:46:56 GMT

@daez,your input field is sting since you should go with below way.

(row2.test.equals("A10") || row2.test .equals( "M10"))? "R": (( row2.test .equals( "D11") || row2.test .equals( "D12") || row2.test .equals( "M12"))?"T": (( row2.test .equals( "C11") || row2.test.equals( "C12") || row2.test.equals( "C13"))?"C": (( row2.test.equals( "999"))?"R":null)))

Re: Tmap " exception in thread " Expresison Builder

daez — Fri, 30 Nov 2018 12:55:18 GMT

@manodwhb, Oh indeed it looks better. Thanks! But my job is still not running :<

Exception in component tMap_1
java.lang.NullPointerException

On the designer we can see 8604 rows on the left & 8603 on the right, like the last one was a problem but it is just like the others so whats wrong? And anyway my last statement of my IF is "null" so ?

My 2 last rows of my file :

Re: Tmap " exception in thread " Expresison Builder

manodwhb — Fri, 30 Nov 2018 13:03:28 GMT

@daez,use the below expression,with this you will not get null pointer exception for this field.

(("A10").equals(row2.test) || ( "M10") .equals(row2.test))? "R": (( ( "D11").equals(row2.test ) || ( "D12").equals(row2.test ) || ( "M12").equals(row2.test ))?"T": (( ( "C11").equals(row2.test) || ( "C12").equals(row2.test)|| ( "C13").equals(row2.test))?"C": (( ( "999").equals(row2.test))?"R":null))

Re: Tmap " exception in thread " Expresison Builder

daez — Fri, 30 Nov 2018 13:23:07 GMT

@manodwhb Working thanks