Trouble Joining layer to Table

183
5
Jump to solution
a month ago
Labels (1)
PeterDormaar
New Contributor II

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

 

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
Waffle_House
Occasional Contributor

@PeterDormaar I recommend you try the following:

  1. Create a File Geodatabase on your local drive.
  2. Import shapefile into a File Geodatabase using Import or Feature Class to Feature Class Tool. The output should be a File Geodatabase Feature Class.
  3. 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.
  4. 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

View solution in original post

0 Kudos
5 Replies
Waffle_House
Occasional Contributor

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

PeterDormaar
New Contributor II

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

0 Kudos
Waffle_House
Occasional Contributor

@PeterDormaar I recommend you try the following:

  1. Create a File Geodatabase on your local drive.
  2. Import shapefile into a File Geodatabase using Import or Feature Class to Feature Class Tool. The output should be a File Geodatabase Feature Class.
  3. 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.
  4. 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

View solution in original post

0 Kudos
KeirenMarshall
Esri Contributor

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?

Esri Australia Consultant and Business Analyst
0 Kudos
DanPatterson
MVP Honored Contributor

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


... sort of retired...
0 Kudos