Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Grouping Similar (but not exact) Field Values Together

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

Re: Grouping Similar (but not exact) Field Values Together

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