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.
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.