Joined data is defined as string and not numbers.

697
1
09-19-2021 11:51 AM
ajkelsey
New Contributor III

I joined a csv to a feature class. For some reason, the joined data is being defined as a string. i did this earlier and didn't have trouble with it being recognized as numbers. How can I make sure it is recognized correctly?

 

0 Kudos
1 Reply
DavidPike
MVP Frequent Contributor

Probably check the formatting of the csv column, if not - try an xls with defined formatting, or import as a geodatabase table, then if it still comes in as a string, add a new float/int field and calculate field. then run the join off that.