Hi,
If you need a user interface, you're probably looking at a plugin. I have no
experience for that. I am sorry to see that the excel function didi not work
for you. I normally turn it off also as it gives rather funny results. I
thought this could be one situation where it could work.
Thanks,
I will keep in mind the idea of making a plugin if I need to accomplish this
task more often in the future. I don’t know if the Python console would work
because there would need to be an interface for the user to manually select
records that can not be matched exactly. Can that be
Hi,
Stick to Excel for now. Keep in mind that Python can be used in the Python
console. Building a for al plugin may not be necessary. Have you tried the
vlookup function? It has a "close match algorithm " by default. That may help.
Nicolas
> Le 5 nov. 2016 à 22:30, Joe Lertola [via
I used to program in my youth so I am familiar with programming concepts. But I
would have to learn python and how to create plugins for Qgis from scratch. So
that is not a project that will happen very fast if I do it. If it turns out
that I have to create a lot of maps like this I might start
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