3 Replies Latest reply on Jul 27, 2016 3:34 PM by swaroop.gantela

    Comma Separated value within a Column - String Values

    S D

      Hello Tableau Gurus,

      I have a dataset that contains a painpoint column that contains a bunch of string values separated by commas (source is MS excel).  As you can notice, each initiative is addressing one or more painpoints. I am trying to figure out an easy way to access this painpoint data in Tableau as individual strings without modifying the source column if possible.

       

      Can anyone think of a way to do this?  Here's an example of the data I'm looking at.

       

      Owner      Initiative           Pain Point

      X               Initiative 1      Phone number, Wrong address, Send e-mail, Mailing Address

      Y               Initiative 2      ID Card, ID Group

      Z               Initiative 3      Contact Lens, Vision Benefits

       

      Thanks,

      SD