topic Null values after joining a csv file to a shapefile layer on ArcGIS Pro in Geoprocessing Questions

Null values after joining a csv file to a shapefile layer on ArcGIS Pro

ErmioniVereketi — Sun, 11 Sep 2022 09:53:17 GMT

Hello everyone,

I am trying to join a csv file to a shapefile layer (points) and after the joining all column values are <NULL>

I checked the joining field to be in the exact same type

Here is my data:

The Shapefile table

The csv file (imported on ArcGIS)

Re: Null values after joining a csv file to a shapefile layer on ArcGIS Pro

DanPatterson — Sun, 11 Sep 2022 10:23:55 GMT

and what were the join fields? I see at least 1 field that looks like a number but is left justified, meaning it is text and not a number

Re: Null values after joining a csv file to a shapefile layer on ArcGIS Pro

ErmioniVereketi — Sun, 11 Sep 2022 10:54:57 GMT

The join fiels are "Loomweight" from the Shape File and "Object" from the csv file

Re: Null values after joining a csv file to a shapefile layer on ArcGIS Pro

DanPatterson — Sun, 11 Sep 2022 18:06:41 GMT

As suspected, Loomweight is a text field (left justified) and Object is numeric (right-justified),

You can't join numbers to text EVEN if they both look like numbers. A common issue. cast one of the fields into a new field to the opposite of what it is using the field calculator (eg int(Loomweight) in a new integer field like LoomWght2)

Re: Null values after joining a csv file to a shapefile layer on ArcGIS Pro

ErmioniVereketi — Wed, 14 Sep 2022 07:13:34 GMT

Many thanks! What I did eventually was to convert the csv file to a dBASE on ArcGIS and then join the dbf file to my shape file