Differences

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

--- transformations:selectbylookup [2021/04/12 00:55] – craigt
+++ transformations:selectbylookup [2021/07/19 02:18] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
 {{ transformations:SelectColumnsWithLookupAction.png}}
-====== SELECT  BY LOOKUP ======
+====== SELECT COLUMNS  BY LOOKUP ======
 Category: Transform / Advanced\\
@@ Line 16: / Line 16: @@
 |Table|Select the table containing the column name values.|
 |Column|Select the column in the selected table that contains the column name values.|
-|Ignore case|When selected, case is not considered when matching column names in the current dataset to the column name\\ values in the second dataset.|
+|Ignore case|When selected, the case is not considered when matching column names in the current dataset to the column name\\ values in the second dataset.|
+The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.\\
 \\
 =====Examples=====
-**Objective:** Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).\\
+**Example:** Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).\\
 \\
 **Table 1:** River lengths.
@@ Line 42: / Line 43: @@
 >Ignore case is "checked"
 \\
-**Result:**
+**Result table:**
 ^River  ^Length (km)  ^Outflow  ^
 | Nile  |  6650|Mediterranean  |
@@ Line 49: / Line 50: @@
 | Mississippi  |  6275|Gulf of Mexico  |
 If //Ignore case// was not checked, the "Length (km)" column would not have been selected.
+\\
+====Community examples====
+  * [[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: //Projects with sandboxes//; Action position: //2//)
 \\
 =====See also=====
-  * [[transformations:remove|Remove Columns]]
+  * [[transformations:remove|Remove columns]]
-  * [[transformations:lookuprename|Rename with lookup]]
+  * [[transformations:lookuprename|Rename columns by lookup]]
-  * [[transformations:select|Select Columns]]
+  * [[transformations:select|Select columns]]