transformations:filter
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:filter [2014/10/03 21:10] – dmitry | transformations:filter [2015/04/10 11:26] – elenap | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Filter by Expression | + | ===== Filter by Condition |
- | This transformation calculates an [[syntax: | + | This transformation calculates an [[syntax: |
The expression should be logical and return a boolean value (i.e. either true or false). | The expression should be logical and return a boolean value (i.e. either true or false). | ||
Line 16: | Line 16: | ||
If no rows satisfy the condition then all rows get removed. | If no rows satisfy the condition then all rows get removed. | ||
+ | |||
+ | **Example of transformation** | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Nile | 6650 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464 | Asia | | ||
+ | | Ob | 5410 | Asia | | ||
+ | | Paraná | ||
+ | |||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Transformation parameters: | ||
+ | |||
+ | * Column: Length (km) | ||
+ | * Expression: [Length (km)] > 6000 | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Nile | 6650 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ |
transformations/filter.txt · Last modified: 2024/03/07 10:22 by dmitry