2 Replies Latest reply: Sep 26, 2015 4:59 AM by Marco Wedel RSS

    Grouping Similar (but not exact) Field Values Together

    Matt Maino

      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.