Update field based on Lookup record tMap

[Anonymous]

Hi,

I am performing a join between two tFileInputPositional in my tMap. Then I would like to update an output field based on an "if-then-else" condition inside tMap. The field I want to change is related to a lookup one. The picture "tMap1" and "Condition" show exactly what I am trying to do. 

The picture "error" shows my Job and the error.

I got this error:

Exception in component tMap_5 (subLoadGal_Alf_4_buono_1_Copy) java.lang.NullPointerException.

Does anyone could help me please?

Thank you in advance!!

[akumar2301]

Can you please do NULL check before equal check.

E.g.

(row.xyz == null || row.xyz.equals("") || row.xyz.trim().equals("")) ? 1234 : 4567

[Anonymous]

Fantastic! It works!! I didn't thought about it.

Thank you!!

[akumar2301 · Accepted solution]

can you please mark the post as resolved.