Question

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


Badge +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

Userlevel 4

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.

Badge +1

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

Reply