1 Reply Latest reply on Jan 21, 2019 4:26 AM by Jim Dehner

    Data with Multiple items in Column - how to split into 'tags'

    Stephen Reid

      Hello

       

       

      I have a CSV file that has a column of data where multiple items are listed separated by comma's   - i.e. "apple,dog,rabbit,dog,tree"

       

      Is it possible for tableau to separate the items as "tags" and use the items within as filter targets?

       

      I read about using split/custom split, but was wondering if there is a cleaner method

       

       

      Cheers

        • 1. Re: Data with Multiple items in Column - how to split into 'tags'
          Jim Dehner

          Good morning

          If you are stuck with the file as input there is not really a clean approach - you could use Prep to split the ata then pivot the columns that result to create a tall narrow data set (from a shorter wider set) - the tall thin data set associate each Tag individually with the apple, dog , cat etc

           

          YOu can also do it in tableau proper but It is a little easier to clean up the data in Prep

          JIm

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          1 of 1 people found this helpful