nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trouble Joining layer to Table

PeterDormaar

Hello, I'm using argis pro. I'm having trouble joining a layer to a table.

The connecting column is formatted the same. Both of them are text. The same values can be found in both the table and the layer.

When I do the join analysis it says there are no matching records. I've reformatted it 20 different times to try and connect them but still can't. I have been able to connect this layer to other tables that have the same values before, but not with this one.

I've heard that it's possible to join the layer to a .csv, but I can't convert the .csv into a table in arcmap.

Any help would be appreciated. Thanks.

--P

Find more posts tagged with

Desktop

Accepted answers

DylanT_EsriCanada

@PeterDormaar I recommend you try the following:

Create a File Geodatabase on your local drive.
Import shapefile into a File Geodatabase using Import or Feature Class to Feature Class Tool. The output should be a File Geodatabase Feature Class.
Import your dbf file into the same File Geodatabase using the Table to Table tool mentioned by the lovely @DanPatterson. The output should be a File Geodatabase Table.
Once these are both inside of the same File Geodatabase, perform your attribute join (documentation).

If this does not work, post screenshots of tool parameters for all tools above.

Cheers

All comments

DylanT_EsriCanada

@PeterDormaar I recommend you try the following:

Create a File Geodatabase on your local drive.
Import shapefile into a File Geodatabase using Import or Feature Class to Feature Class Tool. The output should be a File Geodatabase Feature Class.
Import your dbf file into the same File Geodatabase using the Table to Table tool mentioned by the lovely @DanPatterson. The output should be a File Geodatabase Table.
Once these are both inside of the same File Geodatabase, perform your attribute join (documentation).

If this does not work, post screenshots of tool parameters for all tools above.

Cheers

PeterDormaar

Hey Waffle House, I'm trying to join a table. The table was started as Excel 97-2003 Workbook but is now .dbf, and the layer is a shapefile

danretired

Table To Table (Conversion)—ArcMap | Documentation (arcgis.com)

allows for the import of csv files. Make the destination into a geodatabase so you get a gdb table.

A screen grab of the contents of both files would help to rule out issues like case-sensitivity etc

Anonymous User

Hi,

Are you trying to convert the Table to features? You can try and convert the features and then merge them?

Turn Table To Turn Feature Class—Help | ArcGIS for Desktop

What are files fields/headings that you are trying to merge?

DylanT_EsriCanada

Are you trying to join a table or a csv? What are the file types of the layer and the table?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.