topic Re: Joining csv table to layer results in null values, data types are the same in ArcGIS Pro Questions

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

laperkins — Fri, 23 Dec 2022 23:24:52 GMT

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

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

GoWest — Mon, 26 Dec 2022 15:42:53 GMT

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!

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

laperkins — Tue, 27 Dec 2022 02:14:13 GMT

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