transformations:filter
This is an old revision of the document!
Filter by Condition
This transformation calculates an expression for every row (without adding a new column) and leaves only rows where this expression is true. Other rows are removed.
The expression should be logical and return a boolean value (i.e. either true or false).
Examples of conditions
[Amount]=0 [Length] * [Width] * [Height] <= 1000 contains([City], 'York') not isempty([Email])
If no rows satisfy the condition then all rows get removed.
transformations/filter.1426901614.txt.gz · Last modified: 2015/03/20 21:33 by elenap