Joining SHP with XLS sheet using Excel

Question

Hi, guys,

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

ID NAME CONCATENATE 122765122765345/1765345/1765987/3345987/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.

Any ideas?

danretired · Answer

Another way out possibility is that CONCATENATE may be a reserved word... try CONCAT

JayantaPoddar · Answer

Yes. Try a Table to Excel.

Let me know if you are still unable to Join (by Attribute) with Excel Sheet. If required, in the Excel file, change the cell format of CONCATENATE column to TEXT.

StanislavaV · Answer

yes, that field CONCATENATE in SHP was created that way. but then I need to save attributes as XLS (I will try table to excel) but problem is JOINing xls sheet with shape by field concatenate.

I choose JOIN on that SHAPE and then - 1. field in layer that the join will be based on - CONCATENATE

2. table to join - XLS sheet

3.  field in the table the base to join in - CONCATENATE field does not show up in dropdown menu.