SELECT COLUMNS BY LOOKUP

Category: Transform / Advanced

Description

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.

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.

Example: Keep only the columns in Table 1 that are listed in Table 2 (River, Length (km), and Outflow).

Table 1: River lengths.

River	Length (km)	Continent	Outflow
Nile	6650	Africa	Mediterranean
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)

Action parameters:

Table is "Table 2"
Columns is "Heading names" (in Table 2)
Ignore case is "checked"

Result table:

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)