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