topic Re: null and zero handling for double in Talend Studio

null and zero handling for double

sszzxx — Mon, 25 Mar 2019 02:47:08 GMT

Hi All,

I am trying to do a null handling for a double type column and was given error...

(row1.APPRVD_AMT IS NOT NULL AND row1.APPRVD_AMT<>0)

Can anyone pls assist on how do I convert double to where the value consist of only non nulls and not 0.

Re: null and zero handling for double

vapukov — Mon, 25 Mar 2019 03:41:28 GMT

Hi,

Talend developed on Java and use Java for routines, not SQL.

so proper syntax could be

row1.APPRVD_AMT!=null&&row1.APPRVD_AMT!=0

Relational.isNull(row1.APPRVD_AMT)==0&&row1.APPRVD_AMT!=0

regards, Vlad

Re: null and zero handling for double

sszzxx — Mon, 25 Mar 2019 07:32:44 GMT

hi Vapukov,

Thanks for the reply.

I have tried putting it as you have listed but however I received this error message as I tried to build the job:

the operator !=is undefined for the argument type(s) double,null.

I forgot to point out that my datatype is double for this case ... do I have to cast it to string first before i use the statement you have assist in providing to me for?

Re: null and zero handling for double

vapukov — Mon, 25 Mar 2019 08:29:44 GMT

Hi!

it is work for Double, but not work for double 🙂

you could attach your design

in case of double, you could define the column as not null and assign a default value to it (as variant)