Home Data Prep Q&A


Big News: we’ve moved to the DataRobot Community! Please keep your eye out for an email invitation to join us there. Refer to the We've Moved FAQ for a guide on how to use your existing Paxata Community account to login to our new home.

Visit the official Paxata Documentation portal for all of your doc needs.

Split Text to Multiple Rows

Hi, how do I split a text into multiple rows.
For eg: [Input]
Row Column A Column B
1 Ball Red, Blue, Yellow, Green

[Output]
Row Column A Column B
1 Ball Red
2 Ball Blue
3 Ball  Yellow
4 Ball Green

Answers

  • In order to accomplish your goal, you will need to employ two transformations.

    First, split your Column B into separate columns, as many as the row that has the most values. Then, use the Shape : Depivot capability to generate rows for those values.

    Select the menu option:


    Input the correct separator ", " and accept Paxata's automatic insight on the number of columns to create:


    In Depivot, choose columns that stay put and repeat for every row created, then click REST to make the new columns create rows:

Sign In or Register to comment.