transformations:selectionfilter
This is an old revision of the document!
Filter
This is a filtering transformation that allows quickly finding specific data in a table. Data can be filtered in one column at a time.
Filtered data displays only the rows that meet the pre-defined criteria and hides rows that you do not want displayed.
EXAMPLE
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 out which are the longest rivers in both Americas
Transformation parameters:
- Column: Continent
- Filtering mode: Keep only selected values
- Values: South America; North America
Output table:
River | Length (km) | Continent |
---|---|---|
Amazon | 6400 | South America |
Mississippi | 6275 | North America |
Paraná | 4880 | South America |
See also
transformations/selectionfilter.1428678107.txt.gz · Last modified: 2015/04/10 11:01 by elenap