Transform the table with min and max
Options
sasidharp
Registered Posts: 27 ✭✭✭✭
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. ?
Answers
-
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 Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 411 NeuronOptionsHi @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!
