Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
in my project i want to compare 2 fields (load script); usually under sqlserver i use this functions : Levenshtein or Soundex
but in QV what are the equivalent ?,
i found this function metaphone simple to use ( no documentation )
Any idea ?
I asked the same question a number of months ago and am still waiting for some kind of answer. I think that the only way in which to do anything like this is to use wildcards in a search (which is not the same at all).
On a list bar you can use the fuzzy search by right clicking on the list bar or typing "~"
Sorry not to help further
There are no built in functions in QV like those requested.
But if you search the forum, you might find some useful approaches (depending on your requirements):
Approximate String Matching in QlikView
string matching with fuzzy, trigram (n-gram), levenshtein, etc.
(for a german style Soundex or implement the algorithm from en.wikipedia.org/wiki/Soundex )