EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » rule
transformations:rule

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
transformations:rule [2021/04/01 18:30] – craigttransformations:rule [2021/04/09 00:08] – craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action calculates a new, or replaces an existing, column by using one or several ordered IF...THEN...ELSE conditions. The conditions are checked one by one until a satisfying condition is found. When a satisfying condition is found, the result is calculated and all other conditions are ignored. When no satisfying condition is found, the default calculation is applied. +This action calculates a new, or replaces an existing, column by using one or several ordered IF...THEN...ELSE conditions. The conditions are checked one by one until a satisfying condition is found. When a satisfying condition is found, the result is calculated and all other conditions are ignored. When no satisfying condition is found, the default calculation is applied.\\
- +
-The order of conditions is significant as conditions are checked starting from the first (top). Therefore, conditions that come first have priority over conditions that come later. +
- +
-While the same result can be achieved using an expression with nested [[syntax:functions:if]] functions, the use of Rule action is recommended for clarity, readability, and the ease of rearranging the order. +
-\\ +
  
 \\  \\ 
Line 31: Line 25:
 |Default to|Options:  //it's an expression// or //it's a text or number//.  Enter either an expression to be evaluated, or a static value,\\ in cases where none of the //if// statements evaluate to TRUE.| |Default to|Options:  //it's an expression// or //it's a text or number//.  Enter either an expression to be evaluated, or a static value,\\ in cases where none of the //if// statements evaluate to TRUE.|
 |Keep original value|If none of the //if// statements evaluate to TRUE, retain the original value.| |Keep original value|If none of the //if// statements evaluate to TRUE, retain the original value.|
 +
 +\\ 
 +=====Remarks=====
 +The order of conditions is significant as conditions are checked starting from the first (top). Therefore, conditions that come first have priority over conditions that come later.
 +
 +While the same result can be achieved using an expression with nested [[syntax:functions:if]] functions, the use of Rule action is recommended for clarity, readability, and the ease of rearranging the order.\\
  
 \\  \\ 
Line 68: Line 68:
 =====See also===== =====See also=====
   * [[transformations:addcolumn|Calculate new column(s)]]   * [[transformations:addcolumn|Calculate new column(s)]]
-  * [[transformations:replacecolumn|Modify columns(s)]]+  * [[transformations:replacecolumns|Modify columns(s)]]
   * [[https://community.easymorph.com/t/place-stronger-conditions-first-in-the-rule-action/1113|Community: Place stronger conditions first in the Rule action]]   * [[https://community.easymorph.com/t/place-stronger-conditions-first-in-the-rule-action/1113|Community: Place stronger conditions first in the Rule action]]
transformations/rule.txt · Last modified: 2021/07/19 02:30 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki