Community Conundrum 28: News Engagement is live! Read More

Transform the table with min and max

Level 3
Transform the table with min and max

Hi everyoone,

I am trying to convert the below table 1 to table 2. how can i transform using a prepare recipe. 

Table 1:

timestampsensor1sensor2sensor3sensor4sensor5sensor6
12:510.567198756756.981234
13:510.776187645667.9543
14:510.985176534578.82-148
15:511.194165423489.74-839

 

Table 2:

sensor nameminmax
sensor 10.51.1
sensor 26794
sensor 316541987
sensor 4234567
sensor 556.9889.74
sensor 6-1481234

 

which will be the best way to do this. ?

 

 

0 Kudos
2 Replies
Dataiker
Dataiker

Hi @sasidharp 

You will need to recipes to compute this. The first will be a prepare recipe that uses the Fold multiple columns processor, play with it, should be straightforward.

The next recipe will be a group recipe that computes the min and max as you want them.

Hope this helps!

Hi @sasidharp! I took @Liev  suggestions and created a project showing the process. Most probably it was not needed, but it might help new users in the future.

Cheers!

A banner prompting to get Dataiku DSS