topic am getting exponential in json ouput in Talend Studio

am getting exponential in json ouput

Anonymous — Fri, 11 Oct 2019 14:55:20 GMT

Hello all

When am writing to the json from csv

the data in the csv is data : 39400100000000, but when the data is populated in the json am getting this way "data": "3.94001E+13"

How to rectify the issue

And my data type is string

in the output it is expected in below way

"data": "39400100000000"

Thanks In Advance

Manish

TRF — Fri, 11 Oct 2019 15:04:26 GMT

Change input datatype to String or use the appropriate conversion Double to String using a tJavaRow:

DecimalFormat df1 = new DecimalFormat("#");
output_row.data = input_row.data != null ? df1.format(input_row.data):null;

Anonymous — Fri, 11 Oct 2019 16:19:17 GMT

@TRF thanks it worked