Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
maybe you could calculate the Levenshtein distance for each pair of values (using cartesian peoduct) to find similar values.
see also
regards
Marco