Transform the table with min and max

sasidharp
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:

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

Answers

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    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
    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: 415 Neuron

    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!

Setup Info
    Tags
      Help me…