Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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