combine rows with same value

[sasidharp]

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

TIME	tag1	tag2	tag3	tag4	tag5
00:15:00	1
00:15:00		2
00:15:00			3
00:15:00				4
00:15:00					5
00:30:00		7
00:30:00	6
00:30:00			8
00:30:00					10
00:30:00				9

The Data i need it to be

TIME	tag1	tag2	tag3	tag4	tag5
00:15:00	1	2	3	4	5
00:30:00	6	7	8	9	10

[fchataigner2 · Accepted solution]

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