apologies for what I'm guessing is a really easy problem to solve. GIS user, not programmer here.
I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would like to join a non-spatial table (.csv) containing people who work in each building. So I have multiple records in my table that I would like to be able to join to my single features in my shapefile. I can only run a join in QGIS where the first record is joined to the shapefile feature (ie building) but subsequent records get removed.
Could someone let me know how to complete this join/relate in QGIS?
Thanks for the suggestions, I've downloaded the OSgeo4w installer but it didn't seem to change th efunctionality of the Join tool - not sure what I'm meant to use/do?
I will have a go at the eVis plugin tonight (and report back).
I assume this is a common need in QGIS? I'm taking a table that contains members of an organisation who are spread around a University (so there might be 4-5 members per building) and trying to join that to a shapefile of the University's buildings but I'm only ever left with the first row of my members' table, the other data does not get appended to the shapefile. This is really a relate as opposed to a join isn't it? Would I be better trying to link/relate to the file in Access? rambling now.....