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

  • 25 February 2022
  • 4 replies
  • 0 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

Userlevel 6
Badge +31

What is the source format of the data? CSV?

What is the source format of the data? CSV?

Hi

 

Its a GDB file

Userlevel 6
Badge +31

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

Userlevel 2
Badge +17

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

Reply