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: 
Anonymous
Not applicable

replace empty integer fields in tmap

hello , please i need some help i have many empty fields in column ( integer type ) and i want to replace all empty fields with a number for exemple 3 

i work with talend 5.2.3

i try the equals and the convertion between string and integer but doesn't work 

thank you 

Labels (1)
  • v7.x

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

if the data type of input column is Integer, try this expression:
row1.columnName==null?3:row1.columnName

View solution in original post

2 Replies
Anonymous
Not applicable
Author

if the data type of input column is Integer, try this expression:
row1.columnName==null?3:row1.columnName

Anonymous
Not applicable
Author

thank you , it work . i thought that the empty value and null value are not the same