Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wigchert
Partner - Contributor II
Partner - Contributor II

Fuzzy join possible?

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):

  • DATE
  • VALUE
  • DESCRIPTION

Table MAPPINGS:

  • KEYWORD
  • CATEGORY
10 Replies
amien
Specialist
Specialist

@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 🙂