Differences

This shows you the differences between two versions of the page.

--- transformations:selectionfilter [2015/01/29 23:19] – created dmitry
+++ transformations:selectionfilter [2015/04/10 11:01] – elenap
@@ Line 1: / Line 1: @@
 ===== Filter =====
-This transformation filters rows where certain column contains or doesn't contain any of the listed values.
+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:filter|Filter by condition]]