Feature request #4924

Join attributes - add the option of creating a shapefile with matching attributes only

Added by Filipe Dias about 12 years ago. Updated almost 7 years ago.

Status:Feedback
Priority:Normal
Assignee:Marco Hugentobler
Category:Vectors
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:14728

Description

Currently the output of the join function keeps all records/features of both shapefiles/tables. It would be useful to add the option of keeping only matching records/features during the table join.

This exists in ArcGIS and is explained in this link, under "Joining attributes in one table to another".

http://webhelp.esri.com/arcgiSDEsktop/9.3/index.cfm?TopicName=Joining_tables

Apparently the join function of mmqgis only keeps matching records.

History

#1 Updated by Nathan Woodrow about 12 years ago

I think it would be a good idea to create a memory layer rather then a shapefile, then it can be saved out to disk later.

#2 Updated by Giovanni Manghi almost 12 years ago

  • Target version set to Version 2.0.0

#3 Updated by Pirmin Kalberer over 11 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#4 Updated by Antonio Locandro almost 10 years ago

This is very important feature for some of us that do this often. I believe when doing a join there should be an option to keep matching records or all as follows:

  • Add vector join ***

Join layer -
Join Field -
Target Field -


[x] Keep only matching records (by default)
[ ] Keep all records


[ ] Cache join layer in virtual memory
[ ] Create attribute index on join field

I don't know how other COTS do it but when doing joins I see the fields in the layer where the join is created and I am able to select and do queries on it.

As an extra bonus the possibility to have a check-box to the join to enable/disable it at will

Join layer / Join Field / Target field / Memory Cache / Enable Join

Also currently it only lets you do joins from tables previously loaded to QGIS but in our case we have lots of CSV files we use for joins where we usually just load them at the Join layer stage

#5 Updated by Antonio Locandro almost 10 years ago

Ok so spent 2 hours working around to realize that this is the default behaviour, I should have looked at the issue list first. Joining tables is a very common task and the current state of QGIS makes it very hard to do since one would have to several things before having the result one expects.

BTW I wouldn't want to create a layer each time I do a join which is what mmqgis does at the moment

#6 Updated by Nyall Dawson almost 8 years ago

  • Status changed from Open to Feedback

I don't understand this bug. Are you referring the joining layers using the option under layer properties? Because if so that will only use matching features. Can anyone please clarify?

#7 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No

Also available in: Atom PDF