topic Re: Join had no matches but two attribute fields have same name in ArcGIS Pro Questions

Join had no matches but two attribute fields have same name

dwold — Mon, 06 May 2024 15:26:46 GMT

I get a message saying no matches but my attributes have the same name and are indexed. Both files are in the same geodatabase.

Re: Join had no matches but two attribute fields have same name

Ed_ — Mon, 06 May 2024 15:28:34 GMT

Did you check their data type?

Re: Join had no matches but two attribute fields have same name

dwold — Mon, 06 May 2024 16:11:05 GMT

@Ed_ hello - one is a File Geodatabase Feature Class (points_county_damage), the other is csv table (summary_damage_points_county). Trying to join the table data to the File Geodatabase Feature Class

Re: Join had no matches but two attribute fields have same name

George_Thompson — Mon, 06 May 2024 16:18:35 GMT

Is one of the fields a STRING and the other a NUMERIC?

"The name of the field does not have to be the same, but the data type must be the same; you join numbers to numbers, strings to strings, and so on."
https://pro.arcgis.com/en/pro-app/latest/help/data/tables/joins-and-relates.htm#GUID-39C9610A-6A73-4985-ADB8-7354EA9DB8BF

Re: Join had no matches but two attribute fields have same name

RhettZufelt — Mon, 06 May 2024 17:13:42 GMT

Have you ensured that there are no spaces after the FIPS number in both datasets?

'47005 ' will not join to '47005'

Re: Join had no matches but two attribute fields have same name

dwold — Mon, 06 May 2024 17:29:24 GMT

This was the issue. One was a text the other was long. Once I made both long the join worked. Thanks!

Re: Join had no matches but two attribute fields have same name

Ed_ — Mon, 06 May 2024 17:33:18 GMT

Yup it seems like both the fields have a different data type. so you will have to match those. Usually it's best practice to first import the CSV as a geodatabase table to your database using the "table to geodatabase" tool. And then change the data type accordingly.

CSVs when brought into Pro sometimes have a habit to assigning wrong data types to fields. So maybe the FIPS column in your CSV data was taken as a text field.

Usually with FIPS I just convert the column to a numeric data type as that also removes any extra spaces if there are any.

If this reply helped you then you can also accept this post as an answer, thank you.

Re: Join had no matches but two attribute fields have same name

GF3 — Thu, 19 Sep 2024 17:13:49 GMT

How did you make them both 'long'? I have Attribute Table as text and Join table as Long.

Thank you!

Re: Join had no matches but two attribute fields have same name

Ed_ — Thu, 19 Sep 2024 21:11:34 GMT

if you are saying that one of your matching columns is text and the other is long

then you will first have to create a new column with data type long > go to its calculate field > set it equal to the matching column that is text (assuming that the numbers are stored as text)