Joining SHP with XLS sheet using Excel in arcgis desktop-CodePudding

I am trying to join SHP by field CONCATENATE with my XLS sheet. SHP attributes looks like this:

ID      NAME    CONCATENATE
122      765      122765
345/1   765      345/1765
987/3   345       987/3345

Because of those slashes in ID fields, I choose to TEXT type for field CONCATENATE.

When I open DBF file (from that shp) in Excel, I add a field MATH, where I will calculate, then save it as XLS.

To problem is that when I try to join my SHP by field CONCATENATE with XLS sheet by field CONCATENATE ArcMap can´t offer it in drop-down menu.

CodePudding user response：

Here is what you can do in ArcMap itself.

Add your shapefile to the map.
From Attribute table, add a new field (Datatype: Text). FieldName should be limited to 10 characters for a shapefile.
Use Field Calculator with following expression

Parser: Python

str( !ID! )   str( !NAME! )