Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

am getting exponential in json ouput

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

Labels (3)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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;

View solution in original post

2 Replies
TRF
Champion II
Champion II

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
Not applicable
Author

@TRF thanks it worked