https://community.qlik.com/t5/Talend-Studio/resolved-Convert-with-tConvertType-null-to-new-BigDecimal-0/m-p/2217360#M12989 Hello, <BR />I have an input Db which contains columns only with Varchar and I want to convert this to the right type. Then I want save them in my DB. <BR />But if I use the tConvertType component it cant convert a null Value to a BigDecimal value. <BR />How I can convert null values to new BigDecimal(0)? <BR />thx <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBhI.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142760i81E9BEFA9D6B17AE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBhI.jpg" alt="0683p000009MBhI.jpg" /></span> Fri, 25 Sep 2015 09:19:37 GMT Anonymous 2015-09-25T09:19:37Z https://community.qlik.com/t5/Talend-Studio/resolved-Convert-with-tConvertType-null-to-new-BigDecimal-0/m-p/2217360#M12989 Hello, <BR />I have an input Db which contains columns only with Varchar and I want to convert this to the right type. Then I want save them in my DB. <BR />But if I use the tConvertType component it cant convert a null Value to a BigDecimal value. <BR />How I can convert null values to new BigDecimal(0)? <BR />thx <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBhI.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/142760i81E9BEFA9D6B17AE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBhI.jpg" alt="0683p000009MBhI.jpg" /></span> Fri, 25 Sep 2015 09:19:37 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Convert-with-tConvertType-null-to-new-BigDecimal-0/m-p/2217360#M12989 Anonymous 2015-09-25T09:19:37Z https://community.qlik.com/t5/Talend-Studio/resolved-Convert-with-tConvertType-null-to-new-BigDecimal-0/m-p/2217361#M12990 Hi&nbsp; <BR />Try to convert the data type on tMap with this expression: <BR />row3.newColumn==null?new java.math.BigDecimal(0):new java.math.BigDecimal(row3.newColumn) <BR />Best regards <BR />Shong Mon, 28 Sep 2015 02:21:21 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Convert-with-tConvertType-null-to-new-BigDecimal-0/m-p/2217361#M12990 Anonymous 2015-09-28T02:21:21Z