4 Replies Latest reply on Aug 13, 2018 12:22 AM by Sophie Hong-Dunnett

    Conditional strings grouping

    Sophie Hong-Dunnett

      Hi,

       

      I am trying to create a calculation to first of all, split the customer name for it's first word, then compare that with all the records to see if there are any with the same word. If they are, then group them together

      I am not sure the best way of doing this but I got the splitting working with the following:

      split(customer_name,' ',1)

       

      How do I then use this to compare with the next row and so on... and then group them?

       

      sample data...

       

      Business IT

      Business Ideas

      Telephone General

      Business General

      Telephone Business

       

      The result would be

      Grouping the "Business" first name together and "Telephone" together.

       

      Thanks very much for your help.

      Sophie