Prepare recipe: how to unfold/seperate rows

Solved!
Tong
Level 3
Prepare recipe: how to unfold/seperate rows

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 
1300
2200
3+4240
5200
6300
7+8+9500
10400

 

wish:

Nr temperature 
1300
2200
3240
4240
5200
6300
7500
8500
9500
10400

 

0 Kudos
1 Solution
max
Dataiker

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

View solution in original post

2 Replies
max
Dataiker

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

Tong
Level 3
Author

@max thanks! it works!