Data type conversation in talend

Hi i'am having a input Big Decimal(15,12) value in source in output i am expecting that as string. For example, my source file with value 0.000000000000 by using tmap to convert it into string.

  "String.valueOf(column name)" 

for this im getting output is 0E-12. expected output is 0.0000000000 can anyone provide the solution?

1 Answer

  1. Francis- Reply


    may be this will help

    new BigDecimal("String value").setScale(12, RoundingMode.HALF_DOWN).toPlainString();

Leave a Reply

Your email address will not be published. Required fields are marked *

You can use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>