User Tools

Site Tools


transformations:selectionfilter

FILTER

Category: Transform / Filters


Description

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.


Use cases

  • 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.


Action settings

Setting Description
Filter columnSelect the column containing the values to be used for filtering.
Keep/Remove columnsSelect whether to keep the rows containing the selected values or remove them. Select the individual values
to keep/remove from the list at the bottom of the settings pane. Options: Keep only selected values or
Remove selected values.


Remarks

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.


Examples

Example #1

Output a dataset showing only rivers in North and South America.

Before (source table)

River Length (km) Continent
Nile 6650 Africa
Amazon 6400 South America
Yangtze 6300 Asia
Mississippi 6275 North America
Yenisei 5539 Asia
Yellow River 5464 Asia
Ob 5410 Asia
Paraná 4880 South America

After (result table)

River Length (km) Continent
Amazon 6400 South America
Mississippi 6275 North America
Paraná 4880 South America

Action parameters

Column: Continent
Filtering mode: Keep only selected values
Values selected: South America, North America


Community examples


See also

transformations/selectionfilter.txt · Last modified: 2025/01/29 08:45 by yurii

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki