Skip to main content
Question

Hi ,I have a data set going into a reader and for some reason it is adding a bunch of 0's in certain fields but not all mainly the lm from and to fields in the screenshot, however when I view the file in the data inspector those 0's do not appear

  • February 25, 2022
  • 4 replies
  • 16 views

in the data inspector , and it looks like its just those two columns in the screenshot. is m new to fme and I could just be missing something many thanks in advance

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • February 25, 2022

What is the source format of the data? CSV?


  • Author
  • 1 reply
  • February 25, 2022

What is the source format of the data? CSV?

Hi

 

Its a GDB file


nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2938 replies
  • February 25, 2022

Not sure I understand correct, is it adding zero's to the data or the column names?


daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • 1637 replies
  • February 25, 2022

This may be due to the binary rounding that happens in Float to String conversions:

https://community.safe.com/s/article/why-do-numbers-change-from-float-to-string