Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have the following issue:
One table with transaction data [TRANSACTIONS]. In this table there is a (free format) field that contains the description of the transaction.
Have created a mapping table with keywords and categories [MAPPINGS].
Now I like to use the mapping table in such a way that it searches for the keywords in the description field of the TRANSACTION table. It can then take the categories of the first matching/found keyword.
Are there possibilities in QlikView to do such a fuzzy join or fuzzy mapping?
Table TRANSACTIONS (simplified view):
Table MAPPINGS:
@Rob.. my bad here .. Others is here .. 2 hits .. i wanted to set priorities. but that also works fine .. tested it with "?1*, TestGroup"
@John .. will i was indeed talking about algorithms like q-gram, jaro winkler en Lieberstein. you would need a vbscript to do this. or use a SQL procedure. cause the topic said fuzzy join i was immediately thinking of these algorithms. I don't associate fuzzy match with wildcardmatch 🙂