Skip to main content
Question

Results from FeatureJoiner changing number format

R
Forum|alt.badge.img

I have selected ~50 records from a shapefile of ~5.5 million records using a column of unique reference numbers. The unique reference numbers are stored in a CSV. I have used FeatureJoiner to join the CSV and shapefile.

 

The resulting joined records have been correctly selected but the values in final two columns containing the X and Y coordinates have been altered when viewed in the visual preview.

 

Where in the workspace has the change taken place?

2 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • caracadrianContributor
  • Contributor
  • October 21, 2021

Can you provide some sample data and a sample workspace?

f.kemminje
Contributor
Forum|alt.badge.img+11
  • f.kemminjeContributor
  • Contributor
  • October 22, 2021

write to CSV and check, keep precision for decimal. Sometimes visual previews may show like this.

or you can change the field to text type, in the CSV file.

f.kemminje

Reply


Helpful Members This Week

Community Stats

31,350
Posts
118,924
Replies
38,966
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.