Im wanting to use Qlik to help me match addresses and find the most similar ones. My idea is to break an address down into parts and check how many of them are found in the other string particularly the numbers
here is example
Address To Match Optional Spellings
flat 2 50 boulevard st flat 2 50 boulevard st Match
flat 2 50 boulevard st flat 3 50 boulevard st No Match
flat 2 50 boulevard st 2 50 boulevard Match
Any idea of how I can do this and put more emphsis on the numbers matching? I have tried LevenshsteinDist but it doesn't work for numbers.
I can use Python but its a pain because it doesn't integrate well with our Qlik architecture
Ideally I would want to loop over each part of the name and check it is contained within the other one
Thanks
