Differences

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

--- transformations:rule [2021/04/01 18:30] – craigt
+++ transformations:rule [2021/07/19 02:30] (current) – [Examples] craigt
@@ Line 5: / Line 5: @@
 \\
 =====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 column 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.|
 |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 with 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.\\
 \\
 =====Examples=====
-**Objective:** Add a column describing the average spending potential in each country as low or high, based on the disposable income.
+**Example:** Add a column describing the average spending potential in each country as low or high, based on the disposable income.
 The spending potential is high if the disposable income is $40,000 or more.
@@ Line 45: / Line 45: @@
 | Switzerland  |  53716|  48414|  9.87%|
 | Canada  |  45896|  37469|  18.36%|
+\\
 **Action parameters:**
 >Create new column: Spending
 >Calculated as: if ([Disposable income] > 40000), then HIGH.
->If none of the condition above is met: Default to LOW
+>If none of the conditions above is met: Default to LOW
+\\
-**Output table:**
+**Result table:**
 ^Country  ^Gross income   ^Disposable income  ^Compulsory deductions  ^Spending  ^
 | United States  |  56067|  45582|  18.7%|HIGH  |
@@ Line 58: / Line 57: @@
 | Switzerland  |  53716|  48414|  9.87%|HIGH |
 | Canada  |  45896|  37469|  18.36%|LOW |
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1530/2|Import figures in “scientific format”]] ([[https://community.easymorph.com/uploads/short-url/poEu3Fy9uLb9DdlWKAPN4VoS8XU.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//)
+  * [[https://community.easymorph.com/t//1551/2|How to look up and replace a string of text]] ([[https://community.easymorph.com/uploads/short-url/dvCtD7gg0AHUtXZ7tmQmuHflSYU.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 3//; Action position: //5//)
+  * [[https://community.easymorph.com/t//1686/2|Aggregation of consecutive date ranges]] ([[https://community.easymorph.com/uploads/short-url/xyC5nPd52hGrMiRXjp5w1RVUTYL.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Easymorph Patient Example Data.xlsx//;\\ Action position: //6//)
+  * [[https://community.easymorph.com/t//1697/2|Partial or fuzzy lookup]] ([[https://community.easymorph.com/uploads/short-url/nfnr4o7wX53X2SEaJU5NJ5AzAGt.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Lookup//; Action position: //4//)
+  * [[https://community.easymorph.com/t//1876/2|How to report validation failures?]] ([[https://community.easymorph.com/uploads/short-url/x8xqV8QqQbnnI467dxWdhLbXnFr.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Validate data//; Action position: //2//)
 \\
@@ Line 68: / Line 75: @@
 =====See also=====
   * [[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]]