transformations:selectbylookup
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
transformations:selectbylookup [2018/01/11 21:17] – created dmitry | transformations:selectbylookup [2021/07/19 02:18] (current) – [Examples] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Select columns by lookup | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | Category: Transformation / Advanced | + | \\ |
+ | =====Description===== | ||
+ | This action selects (keeps) columns which names are listed in another table. \\ | ||
- | This transformation selects columns which names are listed in another table. It' | + | \\ |
+ | =====Use cases===== | ||
+ | This action is typically used when the names of columns to select are not known in advance and have to be obtained dynamically during a calculation. | ||
- | **See also** | + | \\ |
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |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, 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===== | ||
+ | |||
+ | **Example:** Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).\\ | ||
+ | \\ | ||
+ | **Table 1:** River lengths. | ||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | |||
+ | **Table 2:** Columns to select (keep) | ||
+ | ^Heading names^ | ||
+ | |River| | ||
+ | |Length (KM)| | ||
+ | |Outflow| | ||
+ | |||
+ | \\ | ||
+ | **Action parameters: | ||
+ | >Table is "Table 2" | ||
+ | >Columns is " | ||
+ | >Ignore case is " | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^River | ||
+ | | Nile | 6650|Mediterranean | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | If //Ignore case// was not checked, the " | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | | ||
+ | | ||
- | * [[transformations: | ||
- | * [[transformations: | ||
- | * [[transformations: |
transformations/selectbylookup.1515723448.txt.gz · Last modified: 2018/01/11 21:17 by dmitry