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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ATeixeira
Contributor II
Contributor II

6 decimal digits precision

Hello,

I have latitude and longitude in a dataset as -52, -70. But I want to transform to a BigDecimal -52.000000, -70.000000.

Can you please help me how to do it in tJavarow or tMap?

Thank you!

Labels (4)
1 Solution

Accepted Solutions
ATeixeira
Contributor II
Contributor II
Author

Already found it

output_row.Longitude = Numeric.convertString2BigDecimal("999999999", input_row.Longitude);

output_row.Latitude = Numeric.convertString2BigDecimal("99999999", input_row.Latitude);

View solution in original post

2 Replies
ATeixeira
Contributor II
Contributor II
Author

The pattern of this field is0693p00000AbMlPAAV.png

ATeixeira
Contributor II
Contributor II
Author

Already found it

output_row.Longitude = Numeric.convertString2BigDecimal("999999999", input_row.Longitude);

output_row.Latitude = Numeric.convertString2BigDecimal("99999999", input_row.Latitude);