User Tools

Site Tools


transformations:searchfilter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:searchfilter [2017/12/23 15:04] (current)
dmitry created
Line 1: Line 1:
 +===== Filter by search =====
  
 +This transformation keeps or removes rows where values in specified column contain particular substring. It also supports filtering using a regular expression.
 +
 +**Example of transformation**
 +
 +**Source table:** The longest rivers in the world
 +
 +^  River  ^  Length (km)  ^  Continent  ^
 +| Nile  |  6650  |  Africa  |
 +| Amazon  |  6400  |  South America  |
 +| Yangtze  |  6300  |  Asia  |
 +| Mississippi  |  6275  |  North America  |
 +| Yenisei  |  5539  |  Asia  |
 +| Yellow River  |  5464  |  Asia  |
 +| Ob  |  5410  |  Asia  |
 +| Paraná  |  4880  |  South America  |
 +
 +
 +**Objective:** Find all rivers that start with 'Y'.
 +
 +**Transformation parameters:**
 +
 +  * Column: River
 +  * Search type: Starts with
 +  * Search string: Y
 +
 +**Output table:**
 +^  River  ^  Length (km)  ^  Continent  ^
 +| Yenisei  |  5539  |  Asia  |
 +| Yellow River  |  5464  |  Asia  |
transformations/searchfilter.txt · Last modified: 2017/12/23 15:04 by dmitry