In transformation, I need to add a new row with and give value to it based on age

VJ
VJ Registered Posts: 1 ✭✭✭✭

Hi

I need help with this. In transformation, I need to add a new row with and give value to it based on age.

using Add a new step, and click on formula, is it possible to do this or is there a different option

when orders< 10, 'low',

when orders >100, 'high'

else 'medium'

Answers

  • lpkronek
    lpkronek Dataiker Posts: 13 Dataiker
    edited July 17

    Hello,

    The formula step will allow you to add a column.

    A formula like the one below will implement the logic you are looking for :

    if(orders<10,"low",if (orders>100,"high","medium"))  

    This will add a new column (not a row). Do not hesitate to let us know more about what you are trying to achieve if that answer does not solve your issue.

Setup Info
    Tags
      Help me…