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'
The formula step will allow you to add a column.
A formula like the one below will implement the logic you are looking for :
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.