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

1471
4
09-11-2022 02:53 AM
ErmioniVereketi
New Contributor II

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

shapefile.jpg

The csv file (imported on ArcGIS)

csv.jpg

0 Kudos
4 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
ErmioniVereketi
New Contributor II

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

0 Kudos
DanPatterson
MVP Esteemed Contributor

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)


... sort of retired...
ErmioniVereketi
New Contributor II

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

0 Kudos