topic Re: Update field based on Lookup record tMap in Talend Studio

Update field based on Lookup record tMap

Anonymous — Tue, 29 Jan 2019 15:58:56 GMT

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!!

Re: Update field based on Lookup record tMap

akumar2301 — Tue, 29 Jan 2019 16:19:10 GMT

Can you please do NULL check before equal check.

E.g.

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

Re: Update field based on Lookup record tMap

Anonymous — Tue, 29 Jan 2019 16:27:57 GMT

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

Thank you!!

Re: Update field based on Lookup record tMap

akumar2301 — Tue, 29 Jan 2019 22:42:12 GMT

can you please mark the post as resolved.