[GIS] Getting “Null” for the joined columns values after joining a shapefile and CSV file in QGIS

attribute-joinscsvlayersqgisshapefile

I am trying to join one CSV file and one shapefile.

This is the shapefile attribute table:

shapefile attribute table

and this is the CSV file.

CSV file

I am getting this as the result:

join result

Does anyone know why I am getting null values in the TyincomeUsa_In… column?

enter image description here

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.

Related Question