When I try to merge my household data file in a .dbf format with my shapefile by using key variable, I get the following error message:
Chosen table merge key field IL contains undefined or duplicate values. Key fields must contain valid unique values.
Because, in my dbf file, provinces have several observations. However, my shapefile has just name of the provinces. So how can I merge these two files in GeoDa?