Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

How to combine several rows to one rows?

Jennnnnny
Level 2
How to combine several rows to one rows?

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?

0 Kudos
1 Reply
MiguelangelC
Dataiker

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

 

0 Kudos