I am trying to join one CSV file and one shapefile.
This is the shapefile attribute table:
and this is the CSV file.
I am getting this as the result:
Does anyone know why I am getting null values in the TyincomeUsa_In… column?
Edit:
What all options do I check in this for the given problem in the case of this CSV data
Best Answer
You are getting null values because the COUNTYNS in shapefile starts with "00" while in CSV file there is "00", which means the there is no common field IDs between shapefile and CSV file. You need to change the type of COUNTYNS field in CSV file from integer number to text and add "00" before each number. Excel will help you to do this job.