Prepare recipe: how to unfold/seperate rows

Options
Tong
Tong Registered Posts: 13 ✭✭✭✭

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

Best Answer

  • max
    max Dataiker Posts: 8 Dataiker
    Answer ✓
    Options

    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

Setup Info
    Tags
      Help me…