Join Features Failed Error

1754
6
02-24-2021 10:11 AM
rmrothen
New Contributor

Hi All, 

I am trying to join a TXT/CSV file to a feature layer by a common variable. I say CSV/TXT because I have tried adding the table in both formats, but in either the FIP code format changes (commas are added). My table has all variables necessary to perform the join, but when I try joining them it says that the join feature failed. Ideally, I want to join the FIP column from EJI3 to the GEOID column from tigerWMScurrent, but I can't fix the format of  FIP in the table. I tried joining by tract because those columns are the same, but that didn't work either. 

I would appreciate any feedback!

 

Screen Shot 2021-02-24 at 12.52.15 PM.png

TXT file [EJI3]

Screen Shot 2021-02-24 at 12.51.55 PM.png

Feature layer [tigerWMScurrent]

Screen Shot 2021-02-24 at 12.51.05 PM.png

  

Screen Shot 2021-02-24 at 1.06.13 PM.png

0 Kudos
6 Replies
JayantaPoddar
MVP Esteemed Contributor

Are you able to open the CSV in MS Excel properly? 

If yes, then save the file in XLS/XLSX format.

Then, use Excel to Table to convert to geodatabase table. Use this table for Join.

Also ensure the TRACT fields are in TEXT and have common values in both the Feature layer table and the non-spatial table.



Think Location
rmrothen
New Contributor

Is the Excel to Table function available on the free online account? I am currently using a student trial version. 

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

This works with ArcGIS Pro.

Do you have access to ArcGIS Pro? It usually comes with the student trial. You could check with your mentor.

Else you could access a 21 days trial from ArcGIS Trial.

In case, you have an active Learn ArcGIS Account, you should be able to download and install ArcGIS Pro.



Think Location
0 Kudos
rmrothen
New Contributor

Ah yes, I haven't installed ArcGIS Pro because I am using a Mac. 

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

I see. Could you attach a sample for testing the data? We can look for a workaround solution.

Also let me know which attribute (FIP of EJI3 or GEOID of tigerWMScurrent) is showing correctly?



Think Location
0 Kudos
rmrothen
New Contributor

Hi I have attached the xlsx file and provided the link for the Tiger data. I know that the FIP variable should match the GEOID variable, but when I upload the file as CSV or TXT it adds commas into the FIP and FIP2 variable. So the GEOID is correct one. 

Tiger data: https://tigerweb.geo.census.gov/arcgis/rest/services/TIGERweb/tigerWMS_ACS2017/MapServer

 

0 Kudos