transformations:rule
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:rule [2015/01/29 23:16] – created dmitry | transformations:rule [2015/04/10 14:47] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
===== Rule ===== | ===== Rule ===== | ||
- | This transformation calculates new or replaces column by using nested IF...THEN...ELSE conditions. While the same result can be achieved using an expression with nested [[syntax: | + | This transformation calculates new or replaces |
Rule transformation is somewhat similar to //switch// or //case// statements in popular programming languages. | Rule transformation is somewhat similar to //switch// or //case// statements in popular programming languages. | ||
+ | |||
+ | 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