Options
How to create new Rows data based on split character values in Column data
I have data like as below
How do i generate new rows based on the column which has , on them
Name | Subject | Grade |
John | Eng,Math | A,B |
Clarice | Eng,Science | O,B |
Kennedy | Math | O |
Kevin | Eng | A |
How do i generate new rows based on the column which has , on them
Name | Subject | Grade |
John | Eng | A |
John | Math | B |
Clarice | Eng | O |
Clarice | Science | B |
Kennedy | Math | O |
Kevin | Eng | A |
Tagged:
0
Best Answer
-
OptionsMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,508 RM Data ScientistHi,you want to use Split+DePivot as operators.
Best,Martin- Sr. Director Data Solutions, Altair RapidMiner -
Dortmund, Germany5
Answers
It is working now .. Thank you