Hi,
I am getting consistent error on joining 46k records from Arcmap Feature to CSV.
Field names containing invalid characters ' ' (screenshot attached for complete error)
I have done following but not luck
1. removed spaces in Excel (do i remove space in arcmap column)
2. checked text format (changed original data format in excel to text and default format didn't help)
3. removed few columns
I am joining on Location_Final Column.
Owner ID | Address | City | Telephone | Location_Final |
0001117 | 31 King Street , 111th Floor | Mycity, AD | 9055461111 | Sec-1 Row-2 Aisle-64 |
0001218 | 31 King Street East, 113th Floor | Mycity, AD | 9055460000 | Sec-1 Row-2 Aisle-65 |
convert the csv to a geodatabase table since there are some efforts made to try to cleanup such data. Then retry the join
Thanks Dan. I have text field to join/connect/ It doesn't fix. Any other help!
Research removing hex characters in Excel. These would be characters you cannot see that will definitely cause join to fail.
Thanks Darrin. I don't find any Hex characters. Other thoughts?