[Qgis-user] linking n to 1 data
Nicolas Cadieux
nicolas.cadieux at archeotec.ca
Sun Jan 24 07:45:16 PST 2016
This is good also.
http://www.qgistutorials.com/en/docs/performing_table_joins.html
Google QGIS one-to-many or many-to-one join and you should find more.
Mmqgis plugin may also have options for you.
Cheers!
Nicolas Cadieux M.Sc.
Les Entreprises Archéotec inc.
8548, rue Saint-Denis Montréal H2P 2H2
Téléphone: 514.381.5112 Fax: 514.381.4995
www.archeotec.ca
On Jan 24, 2016 10:20, "Matthias Kuhn-2 [via OSGeo.org] " <ml-node+s1560n5246972h93 at n6.nabble.com> wrote:
Hi,
There are a number of things to be done to properly support
different usecases:
Join / Aggregate functions support in expressions
Some sort of join possibility should be added to expressions
(similar to the get_feature function) and some aggregate functions.
E.g.
join( "otherlayer"."name", ',' ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"
to create a string like "A,B,C" from three linked entries with name
A, B and C.
Or
average( "otherlayer"."population" ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"
etc...
Relation support for print composer
Create tables with information from related entries based on the
current atlas feature.
Other ideas? I'm sure there is a lot more to be done :-)
Matthias
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
If you reply to this email, your message will be added to the discussion below:
http://osgeo-org.1560.x6.nabble.com/linking-n-to-1-data-tp5246499p5246972.html
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com
To unsubscribe from Quantum GIS - User, click here .
NAML
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/linking-n-to-1-data-tp5246499p5246975.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160124/14cdda30/attachment.html>
More information about the Qgis-user
mailing list