How to combine several rows to one rows?

Options
Jennnnnny
Jennnnnny Registered Posts: 9

Hello,

My data looks like this:

Recordsvalues
records_0_NameJimmy
records_0_Number1
records_0_StatusStudent
records_1_NamesMarie
records_1_Number2
records_1_StatusWorker

And i want it looks like this:

NameNumberStatus
Jimmy1Student
Marie2Worker

Any ideas?

Answers

  • Miguel Angel
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    Hi,

    What you aim to achieve here is a Pivot. This operation can be done in a dedicated Pivot, or Prepare recipes. Given we need first to clean the labels records, the latter recipe is the most straightforward option.

    The following steps:

    Capture11.PNG

    will provide the desired output:

    Capture222.PNG

Setup Info
    Tags
      Help me…