topic Re: Insert null in a column of data type Double in Talend Studio

Insert null in a column of data type Double

ali_hijazi — Wed, 02 Oct 2024 09:24:48 GMT

Hello
I'm working on Talend studio, I have a t_Map
I have a column of type double;
I'm writing the following expression :

row3.t_fixed != null && row3.t_fact != null
?
row3.t_fixed != 0 || row3.t_fact == 0
?
null
:
row3.r_std
:
null

However I'm getting an error saying it's nullPointer Exception
If I replace null with zero the job works fine, but I don't want to put zero but rather null

Kindly advise

Re: Insert null in a column of data type Double

marksouzacosta — Fri, 04 Oct 2024 02:57:35 GMT

Hi @ali_hijazi,

Can you please add a screen shot of your tMap Output Schema and also the log error?

Re: Insert null in a column of data type Double

ali_hijazi — Mon, 07 Oct 2024 14:12:22 GMT

Hello @marksouzacosta
sorry for the late notice

Here is a screen shot of the tmap component
I created a variable called var_tarrifstd of type double
and this is the definition:
when I use null I get an error but when I use null the job works successfully

Re: Insert null in a column of data type Double

fcolagiacomo — Mon, 07 Oct 2024 18:08:29 GMT

The code is Ok, I don't have the error.

row3.t_fixed != null && row3.t_fact != null ? row3.r_std : null

Are you sure the error is in tarifstd field?

Re: Insert null in a column of data type Double

ali_hijazi — Mon, 07 Oct 2024 18:45:25 GMT

Yes the error is raised in tmap component while the field is nullable.

When I put zero then the job finishes successfully

Re: Insert null in a column of data type Double

marksouzacosta — Mon, 07 Oct 2024 19:20:38 GMT

Can you try to replace your whole variable code to just return null and add a tLog after the tMap (deactivating for now the nodes after the tMap)?

Your schemas are looking good so I'm just making sure the problem is in your tMap and on that field.

Re: Insert null in a column of data type Double

fcolagiacomo — Mon, 07 Oct 2024 19:53:11 GMT

Can you make some examples with input values for row3.t_fixed, row3.t_fact, row3.r_std and expected values?

Could you show me the code for variable var_r_currency?

Thanks

Re: Insert null in a column of data type Double

ali_hijazi — Tue, 08 Oct 2024 16:13:55 GMT

it's the same:

but the field currency is of type string and it accepts null as value
I'm pretty sure there is something special about null in double data type

Re: Insert null in a column of data type Double

fcolagiacomo — Fri, 11 Oct 2024 18:01:08 GMT

Hi,

I believe I understand where the problem is.

You are right! If you use a var in tMap as double, Talend build the code like this:

class Var__tMap_1__Struct { double var1; }

So you cannot use null value.

The solution is:

You haven't to use your code in Var field but you have to insert it directly in field Expression of tarifstd.