transformations:selectbylookup
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:selectbylookup [2021/04/12 01:50] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ====== SELECT | ||
+ | Category: Transform / Advanced\\ | ||
+ | |||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action selects (keeps) columns which names are listed in another table. \\ | ||
+ | |||
+ | \\ | ||
+ | =====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. | ||
+ | |||
+ | \\ | ||
+ | =====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, 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: | ||
+ | \\ | ||
+ | **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: | ||
+ | ^River | ||
+ | | Nile | 6650|Mediterranean | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | If //Ignore case// was not checked, the " | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
transformations/selectbylookup.txt · Last modified: 2021/07/19 02:18 by craigt