This question already has an answer here:
I have run into a problem that I see has been posted previously, but none of the posted solutions seem to solve my problem.
- A shapefile (with geometry) with a single row for many counties.
- A CSV file (without geometry) that has multiple rows (representative of different time points) for each county.
Each of these files has an identifier in common “CQID”, which is unique to the county. As such, the shapefile has 1 of each CQID. The CSV has nine of each of the CQID’s (since I have nine time points).
I would like to join the CSV file into the shapefile. So far, I have tried and failed, to solve this problem doing the following:
- Using the Join Feature in the Layer Property of the shapefile.
- Creating a “Relation” of the two files, via Project properties
I expect to look at the attribute table of my shapefile, and see that where I had a single line for each county, there are now nine lines for each.
How do I achieve this is QGIS?
Alternatively, is it easier to do so in ArcMap? Any good tutorials for that?