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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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