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 [2015/03/20 21:33] – elenap | transformations:filter [2021/04/25 14:00] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Filter by Condition | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | The expression | + | The expression |
- | **Examples of conditions** | + | \\ |
+ | =====Use cases===== | ||
+ | Create subsets of a dataset based on values across multiple columns. | ||
+ | |||
+ | Clean a dataset by removing records that don't meet certain criteria, or evaluate to a certain value. \\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Expression|Enter an expression that evaluates to a boolean TRUE/FALSE result. | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | **Examples of valid expressions: | ||
+ | < | ||
[Amount]=0 | [Amount]=0 | ||
| | ||
Line 13: | Line 31: | ||
| | ||
not isempty([Email]) | not isempty([Email]) | ||
- | | + | </ |
+ | |||
+ | If no rows satisfy the condition then all rows are removed.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464| Asia | | ||
+ | | Ob | 5410| Asia| | ||
+ | | Paraná | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Expression: [Length (km)] > 6000 | ||
+ | |||
+ | \\ | ||
+ | **Result: | ||
+ | ^River | ||
+ | | Nile | 6650| Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[syntax: | ||
- | If no rows satisfy the condition then all rows get removed. |
transformations/filter.txt · Last modified: 2024/03/07 10:22 by dmitry