transformations:rule
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
transformations:rule [2021/04/01 18:30] – craigt | transformations: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: | + | |
- | \\ | + | |
\\ | \\ | ||
Line 31: | Line 25: | ||
|Default to|Options: | |Default to|Options: | ||
|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: | ||
\\ | \\ | ||
Line 68: | Line 68: | ||
=====See also===== | =====See also===== | ||
* [[transformations: | * [[transformations: | ||
- | * [[transformations: | + | * [[transformations: |
* [[https:// | * [[https:// |
transformations/rule.txt · Last modified: 2021/07/19 02:30 by craigt