combine rows with same value

Options
sasidharp
sasidharp Registered Posts: 27 ✭✭✭✭

I am trying to rearrange a data in dataiku platform. i am performing several operations, pivoting transposed the data but created more null data. as below

THE data i have

TIMEtag1tag2 tag3tag4tag5
00:15:001
00:15:00 2
00:15:00 3
00:15:00 4
00:15:00 5
00:30:00 7
00:30:006
00:30:00 8
00:30:00 10
00:30:00 9

The Data i need it to be

TIMEtag1tag2 tag3tag4tag5
00:15:0012345
00:30:00678910

Best Answer

  • fchataigner2
    fchataigner2 Dataiker Posts: 355 Dataiker
    Answer ✓
    Options

    Hi,

    you could do a Group recipe using the TIME column as key and max (or min) aggregates for the other columns. You can also rename the columns in the output stage of the group recipe if you want to drop the suffix

Setup Info
    Tags
      Help me…