Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi - Is it possible to add a new column then to populate the rows using the based on criteria that looks at one of the other columns, such as in excel
=IF(B1=1, "Start", "Stop") Where B1 is the column name
?
Thanks
In a word Yes, you can do this.
If you are using a visual recipe, You can "Add a New" formula step. You can then "Open Editor Pannel" and can add a formula.
Note that although this formula language looks a lot like MS Excel Formulas. It is not the same. Here are a few things that threw me off when getting started:
Here is a link to the documentation of the formula language.
Hope this helps. Please let us know how you are getting on with your challanges.
Thanks Tom, as an additional query, what about multiple outputs such as in the excel =IFS(), I can not seem to see a similar option in the formula language details
Mark
If you mean that you want to do something like this.
if(numval('is_rework') == 1 || numval('Titan') == 1, 'Start', 'Stop')
Check out the Operators in the formula language.
Boolean operators: &&, ||
You can also nest if statements.