Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

combine rows with same value

Solved!
sasidharp
Level 3
combine rows with same value
 

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

 

0 Kudos
1 Solution
fchataigner2
Dataiker
Dataiker

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

View solution in original post

1 Reply
fchataigner2
Dataiker
Dataiker

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

View solution in original post

A banner prompting to get Dataiku DSS