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)
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
The join fiels are "Loomweight" from the Shape File and "Object" from the csv file
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)
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