Append data to row from subsequent row

Options
AKendall95
AKendall95 Registered Posts: 1 ✭✭✭

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

Answers

  • Ignacio_Toledo
    Ignacio_Toledo Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 411 Neuron
    Options

    Hi @AKendall95

    I think this might do the trick:

    Hope it helps!

    Ignacio

Setup Info
    Tags
      Help me…