New answers tagged joins
QGIS joins cannot use composite keys. You have to create a combined key attribute column if you want to use the QGIS-internal join functionality. An alternative would be to import the data into Spatialite or PostGIS where you will have more join options including joins on composite keys.
No, you cannot keep the original names. The problem is that DBF files and therefore Shapefile attribute tables have a limit of 10 characters for the column names. When you join two layers, QGIS constructs new attribute names by combining layer and attribute names of the joined layer. To ensure unique column names, QGIS further adds a running number to the ...
Thank you for your patience. Your suggestions on creating file gdb worked in the model. It ran successfully!
I solved this problem for a particular case. I had joined a .csv file to a .shp file and exported the data. I was getting the Rural_I_1 problem described above ... it was appending the file name of the .csv to the field names. My work around was to first export the .csv file as a .dbf table (from arcgis). Then do the join on the .dbf rather than the .csv. ...
Referring to the comment of @GeoKevin try this: Add field (densitiy) to your polygon feature class (Resid). Join your two tables Use field calculator to calculate the field density. Field calculator will has access to both tables (Resid and Occupied)!
Export the joined table into a new shapefile or feature class, and then add the new field.
Top 50 recent answers are included