1 2 3 Previous Next 32 Replies Latest reply on Sep 18, 2015 2:37 AM by William Jones

    Comma Separated value within a Column

    John Mogielnicki

      Hello,

      I have a dataset that contains an activity stream column that contains a bunch of values separated by commas.  Each value represents one minute in a day.  I am trying to figure out if there is a way to use this data in Tableau without writing a sql script to parse each of these values out into it's own minute-level time-stamp to put on separate rows.  Can anyone think of a way to do this?  Here's an example of the data I'm looking at.

       

      DayCustomer IDActivity Stream
      1/1/20131231,4,5,6,7,1,2,5,1,8,5,3,7,8,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5,1,4,5,6,7,1,2,5,1,8,5,3,7,8,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5,1,4,5,6,7,1,2,5,1,8,5,3,7,8,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5
      1/2/20132348,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5,1,4,5,6,7,1,2,5,1,8,5,3,7,8,2,2,1,2,2,2,5,6,7,8,9,9,9,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5,1,4,5,6,7,1,2,5,1,8,5,3,7,8,2,2,1,2,2,2,5,6,7,8,9,9,9,6,5

       

      Thanks,

       

      John

        1 2 3 Previous Next