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. ?
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!