<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
</head>
<body>Am 24.01.2016, 16:45 Uhr, schrieb Nicolas Cadieux <nicolas.cadieux@archeotec.ca>:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><p dir="ltr">This is good also.<br></p>
<p dir="ltr">http://www.qgistutorials.com/en/docs/performing_table_joins.html</p></blockquote><div><br></div><div>Well, I already know how to join data to a layer, thats not the problem and this does not solve 1 to many problems.</div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex">
<p dir="ltr">Google QGIS one-to-many or many-to-one join and you should find more.</p></blockquote><div>Did this extensively over the past 3 years. That's why I only came up with my R approach.</div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex">
<p dir="ltr">Mmqgis plugin may also have options for you.</p></blockquote><div>Can't see anything that makes live there soo much easier except "Geometry Export to CSV" which might produce valid polygon features after reimport.</div><div><br></div><div>But again: Would it be soo hard to make a python script (for pythonists I mean) that iterates over a table, and replicates every matching feature to a new vector layer, adding the attributes? That's what I do with my R script outside of QGIS.</div><div>So, why not just having a 3 click solution instead those numerous exports and reimports and other error-prone single actions?</div><div><br></div><div>Greetings</div><div>Bernd</div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><p dir="ltr"><br>
Cheers!</p>
<p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112 Fax: 514.381.4995<br>
www.archeotec.ca</p>
<div class="gmail_quote">On Jan 24, 2016 10:20, "Matthias Kuhn-2 [via OSGeo.org] " <<a href="/user/SendEmail.jtp?type=node&node=5246975&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type="attribution"><blockquote style="border-left:2px solid #CCCCCC;padding:0 1em" class="quote">
Hi,<br>
<br>
There are a number of things to be done to properly support
different usecases:<br>
<br>
<b>Join / Aggregate functions support in expressions</b><br>
<br>
Some sort of join possibility should be added to expressions
(similar to the get_feature function) and some aggregate functions.
E.g.<br>
<br>
join( "otherlayer"."name", ',' ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"<br>
<br>
to create a string like "A,B,C" from three linked entries with name
A, B and C.<br>
<br>
Or<br>
<br>
average( "otherlayer"."population" ) RIGHT JOIN otherlayer ON
otherlayer."id" = this."fk"<br>
<br>
etc...<br>
<br>
<b>Relation support for print composer</b><br>
<br>
Create tables with information from related entries based on the
current atlas feature.<br>
<br>
Other ideas? I'm sure there is a lot more to be done :-)<br>
<br>
Matthias<br>
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5246972&i=0">[hidden email]
<br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<hr noshade="noshade" size="1">
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/linking-n-to-1-data-tp5246499p5246972.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/linking-n-to-1-data-tp5246499p5246972.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br>
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here.<br>
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML
</div></blockquote></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/linking-n-to-1-data-tp5246499p5246975.html">Re: linking n to 1 data</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br></blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Bernd Vogelgesang<br>Siedlerstraße 2<br>91083 Baiersdorf/Igelsdorf<br>Tel: 09133-825374</div></div></body></html>