transformations:rule
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:rule [2015/01/29 23:16] – created dmitry | transformations:rule [2019/05/30 06:30] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Rule ===== | ===== Rule ===== | ||
- | This transformation | + | This action |
- | Rule transformation | + | 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 after them. |
+ | |||
+ | |||
+ | While the same result can be achieved using an expression with nested [[syntax: | ||
+ | |||
+ | EXAMPLE | ||
+ | |||
+ | **Source table:** Average income and deductions | ||
+ | |||
+ | ^ Country | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada | ||
+ | |||
+ | **Objective: | ||
+ | The spending potential is high if the disposable income is $40,000 or more. | ||
+ | |||
+ | **Transformation parameters: | ||
+ | * Create new column: Spending | ||
+ | * Calculated as: if ([Disposable income] > 40000), then HIGH. | ||
+ | * If none of the condition above is met: Default to LOW | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ Country | ||
+ | | United States | ||
+ | | Australia | ||
+ | | Switzerland | ||
+ | | Canada |
transformations/rule.txt · Last modified: 2021/07/19 02:30 by craigt