<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi Nicolas,<br><br>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.<br><br>Phillip<br><br><br><div><hr id="stopSpelling">Date: Wed, 20 Jul 2016 22:08:55 -0700<br>From: nicolas.cadieux@archeotec.ca<br>To: qgis-user@lists.osgeo.org<br>Subject: Re: [Qgis-user] Joining csv and shape files in QGIS<br><br><p dir="ltr">Hi,</p>
<p dir="ltr">I imagine you are doing a join using the local government field or is this a spacial join?</p>
<p dir="ltr">I imagine you are using a field. Would you have an extra space before the commas? That would through things off.</p>
<p dir="ltr">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.</p>
<p dir="ltr">Is the gov field a unique value field?</p>
<p dir="ltr">Nicolas <br><br><br><br></p>
<div class="ecxgmail_extra"><br><div class="ecxgmail_quote">On Jul 21, 2016 12:30 AM, "Phillip Money [via OSGeo.org]" <<a href="https:///user/SendEmail.jtp?type=node&node=5277483&i=0" rel="nofollow" target="_blank">[hidden email]</a>> wrote:<br><blockquote style="border-left:2px solid #CCCCCC;padding:0 1em;" class="ecxquote">
<div dir="ltr">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.<br><br>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.<br><br>Any help would be appreciated.<br><br>Phillip Money<br><br><br> </div>
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type=node&node=5277479&i=0">[hidden email]
<br>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" target="_blank">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/Joining-csv-and-shape-files-in-QGIS-tp5277479.html" rel="nofollow" target="_blank">http://osgeo-org.1560.x6.nabble.com/Joining-csv-and-shape-files-in-QGIS-tp5277479.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;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></div>
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Joining-csv-and-shape-files-in-QGIS-tp5277479p5277483.html" target="_blank">Re: Joining csv and shape files in QGIS</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" target="_blank">Quantum GIS - User mailing list archive</a> at Nabble.com.<br><br>_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user</div> </div></body>
</html>