4 Replies Latest reply on Feb 23, 2016 5:02 PM by Maggie R

    How to split a column based on a delimiter and maintain it in a one column?

    Maggie R

      Hi there!

       

      I have two dimensional columns Tag and Value. Tag is delimited by pipe symbol. I tried using custom split function to split the tag field but it creates multiple columns; instead I would like to see all the distinct values in a new column( New tag). Please see the screenshot below for additional details.

       

      Is this doable in tableau? Please advise. Thanks!

       

      Capture.PNG