Select to view content in your preferred language

how to keep precision in shape file & scv table join

421
1
04-14-2020 10:42 AM
TatianaVlad
Emerging Contributor

Hello, I am joining  a shapefile with a csv table. One of the fields in the csv table is a double type field that has 9 digits to the right. I need all the digits to the right of the decimal point.

The join is working, looks like the digits are there when I join, but the export of the join brings only 6 digits to the right and many of them are  0 when the  initial attribute  in the csv table was for ex 0.00003300. I am concerned about 0s. 

Thank you so much. 

Tags (1)
0 Kudos
1 Reply
JoeBorgione
MVP Emeritus

Are you really using a shape file or just using that term instead of geodatabse feature class?  If the former, precision in a dbf isn't one of their strong points.

I suggest you perform a table to table to get the csv into a geodatabas table.  You can preserve the field types with the tool, and then you can copy the parameters from a successful tool run if you want to automate it.  Then  make the join to the actual table.

That should just about do it....