Skip to main content
Question

Double value for some values convert to scientific notation using a sde reader - how can I show the actual value.

B
Forum|alt.badge.img+1

The revised dataset uses a sql executor and the value is 0.00001600. The value from the sde is 1.6e-5.

When using a change detector always show as updated when the values have not actually changed. Can I fix this in the sde reader or is there a way to ensure that there is no conversion to scientific notation?

2 replies

david_r
Evangelist
  • david_rEvangelist
  • May 4, 2020

You can use a StringFormater:

You probably also want to use an AttributeRounder set to something meaningful, as comparing floats is notoriously tricky in some cases.

B
Forum|alt.badge.img+1
  • bibold
  • Author
  • May 4, 2020

Worked great once I realize to add to both the origin and revised inputs. Thanks!

Reply


Helpful Members This Week

Community Stats

30,921
Posts
117,175
Replies
38,724
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.