Mapping Poor Address Data-Fuzzy?

[PurplePills555]

Hi All,

Im having some address data trouble. I have a number of agencys whos address I know and want to map.

The issue is the data quality of the entered Address is poor so to find out what address it actually is I need to best fit to my list to the datas list to categorise it.

I need like a fuzzy match or something , any ideas?

Thanks

[walxiney_Planner]

Hello

Do you need find some addres? I dont understande very well, but if you need some function to find some data you can takea look at the match() or wildmatch() function, I don't know if this can help you.

Wildmatch

https://help.qlik.com/pt-BR/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

Match

https://help.qlik.com/pt-BR/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

[jonathandienst]

For simple fuzzy matching, you could use something like this:

LOAD
   dirtyAddress,
   KeepChar(lower(dirtyAddress,'abcdefghijklmnopqrstuvwxyz01234567890)) as matchAddress,

Now matchAddress will match regardless of casing and punctuation.

For more complex matching you might need to find (or make your own) extension that calculates the difference (such as the Levenshtein distance between the strings).

[Vegar]

Maybe you could take a look at this wild match approach? http://biventure.blogspot.com/2011/09/wild-thing-ill-map-your-pattern-strings.html?m=1