Joining csv table to layer results in null values, data types are the same

[laperkins]

Hi I'm trying to join a field from a csv stand alone table to a feature layer using the GISJOIN field. The GISJOIN fields are the same and are of the same data type (text). The result of the Join Field is all null values in the field I'm trying to join. I did something like this 2 months ago and now I can't figure it out, appreciate any help!

From Feature layer:

From csv table:

Both are texts and the same length:

quite frustrating, thanks

[GoWest · Accepted solution]

Try exporting your csv into a File Geodatabase as a Table.  Joining a csv to a Feature Layer directly is error prone.  I hope that helps!

Related:
https://community.esri.com/t5/arcgis-pro-questions/trouble-joining-layer-to-table/m-p/1072375#M42486
https://community.esri.com/t5/arcgis-pro-questions/error-joining-csv-file-to-feature-class/m-p/12422...

[laperkins]

This worked, thank you so much. I used the "Export Table" tool to convert the csv do a geodatabase. Appreciate your help!