Table of Contents
SELECT COLUMNS BY LOOKUP
Category: Transform / Advanced
This action selects (keeps) columns which names are listed in another table.
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.
|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.
Example: Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).
Table 1: River lengths.
|Amazon||6400||South America||Atlantic Ocean|
|Yangtze||6300||Asia||East China Sea|
|Mississippi||6275||North America||Gulf of Mexico|
Table 2: Columns to select (keep)
Table is "Table 2"
Columns is "Heading names" (in Table 2)
Ignore case is "checked"
|Yangtze||6300||East China Sea|
|Mississippi||6275||Gulf of Mexico|
If Ignore case was not checked, the "Length (km)" column would not have been selected.
- Finding all projects with particular action (Project; Module: Main; Group: Tab 1; Table: Projects with sandboxes; Action position: 2)
transformations/selectbylookup.txt · Last modified: 2021/07/19 02:18 by craigt