transformations:searchfilter
This is an old revision of the document!
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.1514041473.txt.gz · Last modified: 2017/12/23 10:04 by dmitry