Address Matching

PurplePills555 — Tue, 15 Jun 2021 16:22:59 GMT

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

topic Address Matching in App Development

Address Matching