topic Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ? in Talend Studio

TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Fri, 15 Nov 2024 23:50:30 GMT

Hi evryone,

I'm using this formula on a tMap component in var section

(

row1.tech_setr1appointementdate!=null

row1.tech_setr2date!=null

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

it's working but when i trie to replace 0 by "null" then i have a errror "java.lang.NullPointerException: null"

(

row1.tech_setr1appointementdate!=null

row1.tech_setr2date!=null

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

null

I have allow the nullable result on the ouput

Thanks for your help 🙂

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Anonymous — Thu, 19 Aug 2021 04:51:39 GMT

try to use this expression on the output rather than Var area, there is no Nullable option in the Var area.

Regards

Shong

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Thu, 19 Aug 2021 05:19:47 GMT

Hello,

Thanks for your quick answer. I got the same result

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Thu, 19 Aug 2021 05:20:14 GMT

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Anonymous — Thu, 19 Aug 2021 08:48:19 GMT

I am not able to reproduce the NPE when I set it to null for a long type. Can you try this expression:

(

row1.tech_setr1appointementdate==null

row1.tech_setr2date==null

)?null:TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd")

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Thu, 19 Aug 2021 13:47:52 GMT

Unfortunately I have the same error

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Fri, 20 Aug 2021 08:08:54 GMT

hi back,

I think it's about a parameters in my TOS 7.3 no ?

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Urba34 — Fri, 20 Aug 2021 15:24:13 GMT

Hi for the futur guys how pass throw this post the answer was to copy past

this code

(

row1.tech_setr1appointementdate!=null

row1.tech_setr2date!=null

TalendDate.diffDate(row1.tech_setr2date,row1.tech_setr1appointementdate,"dd"):

null

directly on the output et and not on the variable

Re: TOS 7.3 - tMap - TalendDate.diffDate why we can not have null as ouput ?

Anonymous — Mon, 23 Aug 2021 07:32:54 GMT

I see you marked this question as resolved and select my answered as best answer. Thanks for your confirmation and feedback.

Regards

Shong