KEEP/REMOVE COLUMNS

Category: Transform / Basic

This action keeps or removes selected columns. Several columns can be kept or removed within a single action.

The action icon will depict whether this action is in "Keep" or "Remove" mode.

Keep columns: Useful for keeping only the selected column(s) regardless of other columns being added or deleted upstream.

Delete columns: Useful for removing columns that are unnecessary for downstream processing. Removing unneeded columns early in the process lowers the computational load on the workflow/system.

A list of columns found in the current dataset is presented to select which columns to keep or remove.

Example 1 (Remove columns): Remove the column describing the length of the river in miles.

Source table: The longest rivers in the world

Action parameters:

Columns to remove: Length (miles)

Result table:

Example 2 (Keep columns): Keep only the River and Continent columns - remove all others.

Source table: The longest rivers in the world

Action parameters:

Columns to keep: River, Continent

Result table:

• Split Excel spreadsheets into multiple spreadsheets (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 2)
• Rounding time to the nearest minute (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 3)
• Data cleaning for data spread over multiple rows and columns (Project; Module: Main; Group: Tab 1; Table: Table 1(3);
  Action position: 2)
• Update existing data in a database table (Project; Module: Main; Group: Tab 1; Table: Where clause; Action position: 4)
• Matrix multiplication (Project; Module: Main; Group: Group 1; Table: Matrix multiplication; Action position: 7)
• API pagination how I create loop (Project; Module: baseProcess; Group: Pull data from API; Table: iterationCalculation;
  Action position: 6)

Fast ways to create the action:

Remove columns:

• Right-click on the column heading and select Remove column from the context menu.
• Click the drop-down arrow in the column heading and select Remove column from the context menu.
• You can remove multiple columns by first selecting the columns to remove, then choosing Remove (#) columnsfrom the context menu.

Keep columns:

• Right-click on the column heading and select Select column from the context menu.
• Click the drop-down arrow in the column heading and select Select column from the context menu.
• You can keep multiple columns by first selecting the columns to keep, then choosing Select (#) columns from the context menu.

• Modify column(s)
• Rename columns
• Reorder columns