https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269737#M47882 <P>Hi Vivek</P> <P>&nbsp;</P> <P>try use this</P> <PRE>new BigDecimal(row1.string_column)</PRE> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-05-11 at 8.59.01 PM.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lu99.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148075iE301EA947BBB8334/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lu99.png" alt="0683p000009Lu99.png" /></span></SPAN>&nbsp;</P> Thu, 11 May 2017 09:58:31 GMT vapukov 2017-05-11T09:58:31Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269736#M47881 <P>Hi All,</P> <P>How can I convert string to bigdecimal in Tmap.I am reading text file from tfileinputdeilimited where data is tagged with doublequotes i.e "8976.3546" .Thus I am reading this data as tring in tfileinputdelimited then trying to convert into bigdecimal in tmap component.Once conversion is done in tmap .bigdecimal data will be inserted into target tables through toracleinput component.Below is screenshot for your reference.</P> <P>Please assist on this issue asap.</P> <P>&nbsp;</P> <P>&nbsp;<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 469px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LtnK.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151552i6E00A43861D5F727/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LtnK.png" alt="0683p000009LtnK.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thamks.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Vivek</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 11 May 2017 08:25:48 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269736#M47881 Anonymous 2017-05-11T08:25:48Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269737#M47882 <P>Hi Vivek</P> <P>&nbsp;</P> <P>try use this</P> <PRE>new BigDecimal(row1.string_column)</PRE> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-05-11 at 8.59.01 PM.png" style="width: 400px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lu99.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/148075iE301EA947BBB8334/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lu99.png" alt="0683p000009Lu99.png" /></span></SPAN>&nbsp;</P> Thu, 11 May 2017 09:58:31 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269737#M47882 vapukov 2017-05-11T09:58:31Z https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269738#M47883 Thanks,That worked... Sat, 27 May 2017 15:11:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-String-to-Bigdecimal/m-p/2269738#M47883 Anonymous 2017-05-27T15:11:10Z