Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray0801
Creator
Creator

How to handle null values in a float column?

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

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@Merffi Ramesh​ ,try the below one.

 

Row1.FloatColumn=NULL ? 0.0: Row1.FloatColumn

 

Thanks,

Manohar

View solution in original post

1 Reply
manodwhb
Champion II
Champion II

@Merffi Ramesh​ ,try the below one.

 

Row1.FloatColumn=NULL ? 0.0: Row1.FloatColumn

 

Thanks,

Manohar