Append data to row from subsequent row

AKendall95
Level 1
Append data to row from subsequent row

Hi All,

I have data similar to the below (a) which I would like to transform to be like below (b). Is this possible in Dataiku, and if so how would I go about this?

Appreciate any guidance you may be able to share.

 

A - Pre-Transformation

GroupValue1Value2
 XYZ789
 ASD654
130001 1,443
 HJK123
130002 123

 

B - Post-Transformation

GroupValue1Value2
130001XYZ789
130001ASD654
130002HJK123
0 Kudos
1 Reply
Ignacio_Toledo

Hi @AKendall95 

I think this might do the trick:

Hope it helps!

Ignacio

0 Kudos