Table of Contents

SELECT COLUMNS BY LOOKUP

Category: Transform / Advanced


Description

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

SettingDescription
TableSelect the table containing the column name values.
ColumnSelect the column in the selected table that contains the column name values.
Ignore caseWhen 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 #1

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

Before (source table)

Table 1: River lengths.

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

Table 2: Columns to select (keep)

Heading names
River
Continent

After (result table)

River Continent
Nile Africa
Amazon South America
Yangtze Asia
Mississippi North America

Action parameters

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


Community examples


See also