FILTER

Category: Transform / Filters

This action filters a dataset based on selected values in a specified column. The action can be set to either keep the rows or remove them.

Create subsets of a dataset based on values in a specific column.

Clean a dataset by removing records that may have "junk" data in a specific column.

Remove or keep records containing a "flag" value in a specific column.

This action keeps or removes rows containing selected whole values in a single column and does not support partial matches or multiple columns.

The choice to use keep vs. remove depends on how you want to handle new values that are introduced in the dataset. If you select specific values to keep, the new values will not appear in the dataset. If you select specific values to remove, the new values will appear in the dataset.

Example: Find out which are the longest rivers in both Americas.

Source table: The longest rivers in the world

Action parameters:

Column is "Continent"
Filtering mode is "Keep only selected values"
Values selected: "South America"; "North America "

Result table:

• Finding all projects with particular action (Project; Module: Main; Group: Tab 1; Table: Documents; Action position: 2)
• Search string on input table (Project; Module: Main; Group: Tab 1; Table: INPUT TABLE.xlsx; Action position: 4)
• Iterate through a set of column (Project; Module: Main; Group: Tab 1; Table: in.csv; Action position: 7)
• Duplicating rows based on a condition (Project; Module: Main; Group: Tab 1; Table: Table 1 (2); Action position: 3)
• Collapsing multiple rows into one (Project; Module: Main; Group: Group 1; Table: Method 1; Action position: 3)
• How to verify uniqueness for a combination of fields (Project; Module: Main; Group: Group 1; Table: Check; Action position: 3)

• Filter by condition
• Filter by search
• Filter by type