https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342261#M2094 <P>Hi </P><P>There exists string value "NULL" in source file, you should read this column as string data type. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Thu, 10 Jun 2021 03:10:21 GMT Anonymous 2021-06-10T03:10:21Z https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342259#M2092 <P>Couldn't parse value for column 'DispTime' in 'row1', value is 'NULL'. Details: java.lang.NumberFormatException: For input string: "NULL"</P><P>DispTime column is of integer type but when I'm converting it to String in tMap, its giving this error due to these NULL in column. Any solution?</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:04:27 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342259#M2092 MAli0012 2024-11-16T00:04:27Z https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342260#M2093 <P>try this : </P><P>Relational.ISNULL(row1.DispTime) ? '' :&nbsp;&nbsp;row1.DispTime.toString()</P><P>&nbsp;</P> Wed, 09 Jun 2021 15:12:08 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342260#M2093 kakooo16 2021-06-09T15:12:08Z https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342261#M2094 <P>Hi </P><P>There exists string value "NULL" in source file, you should read this column as string data type. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Thu, 10 Jun 2021 03:10:21 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342261#M2094 Anonymous 2021-06-10T03:10:21Z https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342262#M2095 <P>It worked, thanks @Shicong Hong​&nbsp;</P> Thu, 10 Jun 2021 16:32:15 GMT https://community.qlik.com/t5/Talend-Data-Catalog/Int-to-String-Number-Format-Exception/m-p/2342262#M2095 MAli0012 2021-06-10T16:32:15Z