Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Prepare recipe: how to unfold/seperate rows
Added on February 5, 2021 8:31AM
Likes: 0
Replies: 2
Tong
Registered Posts: 14 ✭✭✭✭
I have a table like below. There are some rows, which are combined in one row, because the parameters are the same. For the data cleaning, I want seperate them (like below the second table). How can I do it? Thanks for your help!
Original
| Nr | temperature |
| 1 | 300 |
| 2 | 200 |
| 3+4 | 240 |
| 5 | 200 |
| 6 | 300 |
| 7+8+9 | 500 |
| 10 | 400 |
wish:
| Nr | temperature |
| 1 | 300 |
| 2 | 200 |
| 3 | 240 |
| 4 | 240 |
| 5 | 200 |
| 6 | 300 |
| 7 | 500 |
| 8 | 500 |
| 9 | 500 |
| 10 | 400 |
Best Answer
-
Hi @Tong
,From the prepare recipe, you can use the processor called "Split and Fold", using "+" as the separator. This should transform your data into what you are looking for.
Do not hesitate if you have any further questions.
Max
Answers
-
@max
thanks! it works!