[Qgis-user] Joining data to a shape file by country name when the names don't match exactly

[Nicolas Cadieux]

Hi,

You  always add the coordinates of the point data and then make a spatial join instead of a join based on names...  If not, the vlookup function in excel would let you see what data does not match based on the names.

Nicolas

> Le 4 nov. 2016 à 22:13, Joe Lertola [via OSGeo.org] <ml-node+s1560n5294403h54 at n6.nabble.com> a écrit :
> 
> Hello.
> 
> Today I made a thematic map by joining a list of data that had country names to a shape file of world countries. I had to spend a lot of time working in Excel to make my data names match the names in the shape file. A lot of them already matched but there were many that didn’t. For example the the shape file had Ivory Coast and the data had Cte d’Ivoire as the name. Is there any way to do this in Qgis instead of Excel? Years ago I recall doing this in ArcMap. There was a tool that matched up the data where it could and then for each record that wasn’t matched you could choose the matching record manually. Any help would be greatly appreciated.
> 
> Thanks,
> -Joe
> 
> 
> _______________________________________________ 
> 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/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403.html
> To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38 at n6.nabble.com 
> To unsubscribe from Quantum GIS - User, click here.
> NAML




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Fwd-Joining-data-to-a-shape-file-by-country-name-when-the-names-don-t-match-exactly-tp5294403p5294405.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/20161104/49f90fb8/attachment.html>