https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305586#M77225 hi,<BR />apply toString() to your BigDecimal .<BR /><PRE>/* example in a tJava*/<BR />BigDecimal bg = new BigDecimal(0.12235645,new java.math.MathContext (8)); //precision 8<BR />System.out.println(bg.toString());</PRE><BR /><PRE>Starting job bigd at 16:00 29/08/2013.<BR /> connecting to socket on port 4042<BR /> connected<BR />0.12235645<BR /> disconnected<BR />Job bigd ended at 16:00 29/08/2013. </PRE><BR />see java doc for BG : <A href="http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html" rel="nofollow noopener noreferrer">http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html</A><BR />that give you 3 different methods to convert BG to String<BR />regards<BR />laurent Thu, 29 Aug 2013 14:57:19 GMT Anonymous 2013-08-29T14:57:19Z https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305585#M77224 Hi Members, <BR />We have faced the issue to Convert the BigDecimal to String while execute the Job. can anyone provide the solution? <BR />Regards, <BR />Venkateswarlu. Thu, 29 Aug 2013 14:28:30 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305585#M77224 Anonymous 2013-08-29T14:28:30Z https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305586#M77225 hi,<BR />apply toString() to your BigDecimal .<BR /><PRE>/* example in a tJava*/<BR />BigDecimal bg = new BigDecimal(0.12235645,new java.math.MathContext (8)); //precision 8<BR />System.out.println(bg.toString());</PRE><BR /><PRE>Starting job bigd at 16:00 29/08/2013.<BR /> connecting to socket on port 4042<BR /> connected<BR />0.12235645<BR /> disconnected<BR />Job bigd ended at 16:00 29/08/2013. </PRE><BR />see java doc for BG : <A href="http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html" rel="nofollow noopener noreferrer">http://docs.oracle.com/javase/6/docs/api/java/math/BigDecimal.html</A><BR />that give you 3 different methods to convert BG to String<BR />regards<BR />laurent Thu, 29 Aug 2013 14:57:19 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305586#M77225 Anonymous 2013-08-29T14:57:19Z https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305587#M77226 For numbers smaller than 0.00001, .toString() gives you exponential notation i.e. 1E-6. Use .toPlainString() instead. Mon, 02 Sep 2013 01:08:33 GMT https://community.qlik.com/t5/Talend-Studio/How-to-Convert-BigDecimal-to-String/m-p/2305587#M77226 alevy 2013-09-02T01:08:33Z