Transform the table with min and max

[sasidharp]

Hi everyoone,

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

Table 1:

timestamp	sensor1	sensor2	sensor3	sensor4	sensor5	sensor6
12:51	0.5	67	1987	567	56.98	1234
13:51	0.7	76	1876	456	67.9	543
14:51	0.9	85	1765	345	78.82	-148
15:51	1.1	94	1654	234	89.74	-839

Table 2:

sensor name	min	max
sensor 1	0.5	1.1
sensor 2	67	94
sensor 3	1654	1987
sensor 4	234	567
sensor 5	56.98	89.74
sensor 6	-148	1234

which will be the best way to do this. ?

[Liev]

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!

[Ignacio_Toledo]

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!