Hi Nicolas, It is a table join. The common field is the name of the local government area (city/shire). They are common in both tables. I just noticed that one is in caps and the other isn't. I will try putting both the same case and see how that goes.
Phillip Date: Wed, 20 Jul 2016 22:08:55 -0700 From: [email protected] To: [email protected] Subject: Re: [Qgis-user] Joining csv and shape files in QGIS Hi, I imagine you are doing a join using the local government field or is this a spacial join? I imagine you are using a field. Would you have an extra space before the commas? That would through things off. Try loading the shapefile and the csv data without the join? Then, copy a government value from the shapefile then try to find it using a query or a filter in the csv. If you know it's there and can't find it, then you could have a character or something throwing off the join. Is the gov field a unique value field? Nicolas On Jul 21, 2016 12:30 AM, "Phillip Money [via OSGeo.org]" <[hidden email]> wrote: I am trying to join a csv file and shp file in QGIS. They both have common fields. I have imported the CSV file properly. It has two fields, a name (local government area) and an integer (total complaints per area). I have checked the properties in QGIS and they show string and int. I want to display total complaints per local government area on a map When I join the CSV and shp files, I get null values under the total complaints field. I have tried lots of things, but without success so far. Any help would be appreciated. Phillip Money _______________________________________________ Qgis-user mailing list <a href="/user/SendEmail.jtp?type=node&node=5277479&i=0">[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/Joining-csv-and-shape-files-in-QGIS-tp5277479.html To start a new topic under Quantum GIS - User, email [email protected] 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. <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 View this message in context: Re: Joining csv and shape files in QGIS Sent from the Quantum GIS - User mailing list archive at Nabble.com. _______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
