Community Conundrum 25: Feature Visualization is now live! Read More

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

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

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'

1 Reply
Dataiker
Dataiker

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. 

 

LPK