Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 |
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
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
@max thanks! it works!