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: 
Not applicable

Grouping Similar (but not exact) Field Values Together

Hi,

I am trying to group together descriptions of credit card transactions so I am able to see how many times a specific credit card was used at the same place over a period of time. The problem is that the description for a specific transaction is not exactly the same (but similar) each time it occurs. Is there a way to group together values in a field based on how similar they are to each other? See example below:

09/01 NETFLIX.COM CA

10/02 NETFLIX.COM

NETFLIX.COM CA

I would like all of these to group into the same bucket.

Thanks.

2 Replies
Gysbert_Wassenaar

You can try using a mapping table and the applymap function, but you'll have to create such a table first and then maintain it manually.

Or perhaps one of these helps:

Teaching the load script new tricks

String Comparison


talk is cheap, supply exceeds demand
MarcoWedel

maybe you could calculate the Levenshtein distance for each pair of values (using cartesian peoduct) to find similar values.

see also

Levenshtein Algorithm

regards

Marco