SELECT COLUMNS BY LOOKUP

Category: Transform / Advanced

Description

This action selects (keeps) columns whose 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.

Keep only the columns in Table 1 that are listed in Table 2 (River and Continent.

Table 1: River lengths.

#	River	Length (km)	Continent
1	Nile	6650	Africa
2	Amazon	6400	South America
3	Yangtze	6300	Asia
4	Mississippi	6275	North America

Table 2: Columns to select (keep)

Heading names
River
Continent

Table: Table 2
Column: Heading names (in Table 2)

Finding all projects with particular action (Project; Module: Main; Group: Tab 1; Table: Projects with sandboxes; Action position: 2)