Merge/Group rows based on metrics

Logeshwar
Logeshwar Registered Posts: 5
edited February 4 in Using Dataiku

I am trying to merge/Group rows based on metric range.

Present format

Desired format

Best Answer

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,252 Neuron
    Answer ✓

    Add a Prepare recipe and create a new houses_group column using a formula as follows:

    if(cars > 1, "Houses with more than 1", "Houses with 1 car")
    

    Then on the resulting output dataset add a Group By recipe and group by houses_group.

Answers

Setup Info
    Tags
      Help me…