2 Replies Latest reply on Oct 31, 2018 8:05 AM by Stefan Vasile

    Text to ROWS (like text to columns in excel)

    Stefan Vasile

      Hello dears,

       

      is there a way to do a "text to rows" with Tableau, given a delimiter, so the Split would go vertically, multiplying (copying again) the rest of the data?

       

      This example:

       

      Practically i need to split columns C, D, and E, by the "/" sign, on new rows. So the result would be 3*6*3 = 54 rows instead of the first row. It would give me all the possible combinations of the data given the options.

       

      Thank you so much

       

      Stefan