how to keep precision in shape file & scv table join

39
1
04-14-2020 10:42 AM
TatianaVlad
New 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 Esteemed Contributor

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.

can't wait to retire....