[Qgis-user] Relations table

[Matt Boyd]

Thanks,
I ended up creating a virtual layer which enabled me to join the columns I
needed using standard SQL terms (inner join was the one I wanted).
Matt

On Wed, Mar 4, 2020 at 6:21 PM <labrinos at eled.auth.gr> wrote:

>
> Hi Matt,
>
> You have to have a common column in both tables (QGIS table and
> spreadsheet). The cells in both columns of the tables must contain
> exactly the same values.
> Then, open the layer in QGIS, go to properties and choose Connections.
> Then go to (+) symbol and follow the instructions.
>
> Nikos
>
>
> Παραθέτοντας από Matt Boyd <mattslists at gmail.com>:
>
> > Hi QGISers,
> > I'm trying to work out how to link up a table of data with no spatial
> > information to a gis layer with locations.
> > Each location has more than one property, the property is in an excel
> > spreadsheet.
> > I want to use the location data from the GIS layer and the properties
> from
> > the table to classify the points. Both of these datasets are maintained
> > separately and I need to be able to bring them back together for
> analysis.
> >
> > I'm having trouble getting all of the results for a point in the table to
> > link to the location.
> >
> > Any tips on this?
> > Thanks
>
>
>
> --
> Δρ. Νίκος Λαμπρινός
> Καθηγητής της Διδασκαλίας της Γεωγραφίας
> Τμήμα Δημοτικής Εκπαίδευσης
> Α.Π.Θ. 54124 Θεσσαλονίκη
> Τηλ.: 2310 991201 / 991230
> Email: labrinos at eled.auth.gr
> Web Page: http://users.auth.gr/labrinos/
>           http://www.digital-earth.edu.gr/
>           https://www.auth.gr/univUnits
>
> ---------------------------------------------------------------------
> Dr. Nikos Lambrinos
> Professor of Geography Teaching
> Director of the Sector of Science and New Technologies
> President of the Hellenic digital earth Centre of Excellence
> Faculty of Education
> School of Primary Education
> Dept. of Science and New Technologies
> Aristotle University of Thessaloniki
> GR-54124 Thessaloniki, Greece
> Tel: +30 2310 991201
> Email: labrinos at eled.auth.gr
> Web Page:     http://users.auth.gr/labrinos/
>               http://www.digital-earth.edu.gr/
>               https://www.auth.gr/en/univUnits
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200304/86e1c1cd/attachment.html>