2 Replies Latest reply on Sep 25, 2012 11:27 AM by Alan Kwan

    Categorizing words within String

    Alan Kwan

      Hi all,

       

      I have a set of data with a field called "Problem Short Description". For example,

       

      "MS Outlook cannot send email"

      "Outlook asking for password"

       

      Unfortunately, there is no existing field that categorizes these.

       

      So, my question is..what is the best way/formula to do this in Tableau?

       

      Currently, the only way I can think of is...

       

      iif(Contains([Problem Short Description], "password"), "Password",

      iif(.........)

       

      The list goes on and on, the cons of this are that it gets very slow with all the iifs, and the Contains formula is case sensitive..meaning password and Password are different so I have to type it twice...

       

      Suggestions?

       

      Thanks,

      Alan