I have a shapefile and a csv file that I want to join. The csv file has:
- MSA identifiers
- County identifiers within MSA (so, across MSAs the county_id is not unique)
- a series of attributes (each column with zeros and ones) that I want to add to the shapefile.
The shapefile has the MSA identifier and the county identifier (again, unique within MSA, not across MSAs).
How can I join the shapefile and csv file, when the join operation has to be based on two attributes of the shapefile and csv file? Both "Add vector join" and "Attributes join from csv" (mmQGIS) seem to allow for joins with a single attribute as identifier.