Differences

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

--- transformations:selectionfilter [2015/04/10 11:05] – elenap
+++ transformations:selectionfilter [2021/07/19 01:03] (current) – craigt
@@ Line 1: / Line 1: @@
-===== Filter =====
+{{ transformations:SelectionFilterAction.png}}
+====== FILTER ======
+Category: Transform / Filters\\
-This is a filtering transformation that allows finding specific data in a table. Data can be filtered in one column at a time.
+\\
+=====Description=====
+This action filters a dataset based on selected values in a specified column.  The action can be set to either keep the rows or remove them.\\
-Filtered data displays only the rows that meet the pre-defined criteria and hides rows that you do not want displayed.
+\\
+=====Use cases=====
+Create subsets of a dataset based on values in a specific column.
-EXAMPLE
+Clean a dataset by removing records that may have "junk" data in a specific column.
-**Source table:** The longest rivers in the world
+Remove or keep records containing a "flag" value in a specific column.
-^  River  ^  Length (km)  ^  Continent  ^
+\\
-| Nile  |  6650  |  Africa  |
+=====Action settings=====
-| Amazon  |  6400  |  South America  |
+^Setting ^Description ^
-| Yangtze  |  6300  |  Asia  |
+|Filter column|Select the column containing the values to be used for filtering.  |
-| Mississippi  |  6275  |  North America  |
+|Keep/Remove columns|Select whether to keep the rows containing the selected values or remove them.  Select the individual values\\ to keep/remove from the list at the bottom of the settings pane.  Options:  //Keep only selected values// or\\ //Remove selected values//.|
-| Yenisei  |  5539  |  Asia  |
-| Yellow River  |  5464  |  Asia  |
-| Ob  |  5410  |  Asia  |
-| Paraná  |  4880  |  South America  |
+\\
+=====Remarks=====
+This action keeps or removes rows containing selected whole values in a single column and does not support partial matches or multiple columns.\\
-**Objective:** Find out which are the longest rivers in both Americas
+The choice to use //keep// vs. //remove// depends on how you want to handle new values that are introduced in the dataset.  If you select specific values to //keep//, the new values will not appear in the dataset.  If you select specific values to //remove//, the new values will appear in the dataset.\\
-**Transformation parameters:**
+\\
+=====Examples=====
+**Example:** Find out which are the longest rivers in both Americas.\\
-  * Column: Continent
+**Source table:** The longest rivers in the world
-  * Filtering mode: Keep only selected values
+^River  ^Length (km)  ^Continent  ^
-  * Values: South America; North America
+| Nile  |  6650| Africa  |
+| Amazon  |  6400| South America  |
-**Output table:**
+| Yangtze  |  6300| Asia  |
+| Mississippi  |  6275| North America  |
+| Yenisei  |  5539| Asia  |
+| Yellow River  |  5464| Asia  |
+| Ob  |  5410| Asia  |
+| Paraná  |  4880| South America  |
+\\
+**Action parameters:**
+> Column is "Continent"
+> Filtering mode is "Keep only selected values"
+> Values selected: "South America"; "North America  "
+\\
+**Result table:**
+^River  ^Length (km)  ^Continent  ^
+| Amazon  |  6400| South America  |
+| Mississippi  |  6275| North America  |
+| Paraná  |  4880| South America  |
-^  River  ^  Length (km)  ^  Continent  ^
+\\
-| Amazon  |  6400  |  South America  |
+====Community examples====
-| Mississippi  |  6275  |  North America  |
+  * [[https://community.easymorph.com/t//1475/1|Finding all projects with particular action]] ([[https://community.easymorph.com/uploads/short-url/cM8AssOT6zQXD8JDr9adUAy2sDM.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Documents//; Action position: //2//)
-| Paraná  |  4880  |  South America  |
+  * [[https://community.easymorph.com/t//1553/2|Search string on input table]] ([[https://community.easymorph.com/uploads/short-url/c6LLWynH5coI6B0jJUssVNK0ycA.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //INPUT TABLE.xlsx//; Action position: //4//)
+  * [[https://community.easymorph.com/t//1849/4|Iterate through a set of column]] ([[https://community.easymorph.com/uploads/short-url/5icrGfTGgzbmG2l5AuSiqb43QvR.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //in.csv//; Action position: //7//)
+  * [[https://community.easymorph.com/t//2017/3|Duplicating rows based on a condition]] ([[https://community.easymorph.com/uploads/short-url/blETeOO6qUVzskyO2eYqMiNvjPP.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1 (2)//; Action position: //3//)
+  * [[https://community.easymorph.com/t//2321/4|Collapsing multiple rows into one]] ([[https://community.easymorph.com/uploads/short-url/j6CBEKHa76q1v9oQqui4UPWN7ro.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Method 1//; Action position: //3//)
+  * [[https://community.easymorph.com/t//2616/2|How to verify uniqueness for a combination of fields]] ([[https://community.easymorph.com/uploads/short-url/cLNzPfyWH0UyLiDDFC4JnIkbzJN.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Check//; Action position: //3//)
-=== See also ===
+\\
+=====See also=====
   * [[transformations:filter|Filter by condition]]
+  * [[transformations:searchfilter|Filter by search]]
+  * [[transformations:filterbytype|Filter by type]]