[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