Join had no matches but two attribute fields have same name

[dwold]

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

[Ed_]

Did you check their data type?

[dwold]

@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

[Ed_ · Accepted solution]

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.

[George_Thompson · Accepted solution]

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-4...

[dwold]

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

[GF3]

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

Thank you!

[Ed_]

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) 

[RhettZufelt]

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

'47005 ' will not join to '47005'

R_