Sunday 17 March 2019

arcgis desktop - Changing field type of Excel attribute table for a Join


I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field type for the excel file is a Double.


The excel field is all numbers, but the shapefile field is mostly numbers and a few letters mixed in, I think thats why it came out as a string.


I know you can't add a field or use the field calculator into a table exported from excel, I'm currently using it as a .csv.




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...