User Tools

Site Tools


transformations:searchfilter

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