How to handle null values in a float column?

Ray0801 — Wed, 24 Mar 2021 06:06:16 GMT

Hi,

I am trying to handle null values in a float column,

this is the code,I am writing for null handling

Row1.FloatColumn=NULL?0:

Row1.FloatColumn

Talend is throwing a error saying 0 is a int ,

what value should I place there instead of 0.

I am using Talend Open Studio 7.3.1 DI

Re: How to handle null values in a float column?

manodwhb — Wed, 24 Mar 2021 14:11:15 GMT

@Merffi Ramesh ,try the below one.

Row1.FloatColumn=NULL ? 0.0: Row1.FloatColumn

Thanks,

Manohar