In transformation, I need to add a new row with and give value to it based on age
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
-
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.