Home Data Prep Q&A

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

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.