Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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!