Skip navigation

Text to Rows >> Tableau Prep

score 13
You have not voted. Active

Similar to "text to columns" >> add additional "text to rows" function

 

If you have a cell with variable data inputs, currently in Tableau Prep to split/pivot vertically you must:

     1) split on the deliminator using text to columns (currently limited to 10 split columns which is a miss)

     2) figure out the "MAX" number of entries (if >10, you are in a pickle)

     3) pivot the new created split columns into rows

     4) clean the (null) values from the over split

 

I have a case where the one cell could have [0 or 18] values with theoretical [42] unique inputs.

 

  RAW DATA - BEFORE

Customer#Eval Results
1SL-1A; SL-2A; SL-1B; SL-2C; PH-1A; PH-2A; PH-3A; PH-3B; BT-3A; BT-3B
2BT-3A
3BT-3A; BT-3B

 

PREP DATA - AFTER

Customer#Eval Results
1SL-1A
1SL-2A
1SL-1B
1SL-2C
1PH-1A
1PH-2A
1PH-3A
1PH-3B
1BT-3A
1BT-3B
2BT-3A
3BT-3A
3BT-3B

 

If "text to rows" we're a feature, it would avoid operations/considerations 2,4 shown above.

Comments

Vote history