combine rows with same value
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
| 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 |
Best Answer
-
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
