User Tools

Site Tools


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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki