topic Re: replace empty integer fields in tmap in Talend Studio

replace empty integer fields in tmap

Anonymous — Thu, 28 May 2020 13:14:48 GMT

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

Re: replace empty integer fields in tmap

Anonymous — Tue, 02 Jun 2020 11:30:26 GMT

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

Re: replace empty integer fields in tmap

Anonymous — Tue, 02 Jun 2020 11:57:48 GMT

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