Join Features Failed Error

Question

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!

TXT file [EJI3]

Feature layer [tigerWMScurrent]

rmrothen · Answer

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

EJI3_sample.xlsx

JayantaPoddar · Answer

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?

rmrothen · Answer

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