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

[VJ]

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'

[lpkronek]

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.