Very interesting Nyall 

That makes me remember that the vlookup in excel also has a "bests match" by 
default.  I always turn it off because it uses the first found possible match.  
I wonder if it uses the same type of "Fuzzy" logic...?  

Nicolas

> Le 4 nov. 2016 à 23:22, Nyall Dawson [via OSGeo.org] 
> <ml-node+s1560n5294406...@n6.nabble.com> a écrit :
> 
> On 5 Nov 2016 12:13 PM, "Joe Lertola" <[hidden email]> wrote:
> >
> > 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.
> 
> How good are your python skills? Sounds like a perfect candidate for a new 
> processing algorithm. QgsStringUtils has methods for performing "fuzzy" 
> matching of strings, so a lot of the hard work is already done.
> 
> Nyall
> 
> >
> > 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
> 
> 
> _______________________________________________ 
> 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-tp5294403p5294406.html
> To start a new topic under Quantum GIS - User, email 
> ml-node+s1560n4125267...@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-tp5294403p5294431.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
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

Reply via email to