Filter Activity
The Filter activity enables the extraction of specific data subsets from an existing dataset based on defined criteria. It processes the input dataset and generates a new dataset containing only the records that meet the filter expression requirements.
| Field | Description | Requirement |
|---|---|---|
| Dataset name | The reference name of the source dataset to be filtered. | Required |
| Filter | The logical expression used to define the filtering criteria. | Required |
| New dataset name | The name assigned to the resulting dataset containing the filtered data. | Required |
Action Types & Examples
Logical Comparison
- Format: string or numeric expression
- Example Result:
$"ad"="ilhan" and $"Numara"=5
String Pattern Matching
- Format: string expression using keywords
- Example Result:
$"ad" begins with "il" or $"ad" contains "han"
Dynamic Variable Filtering
- Format: string expression with variable placeholders
- Example Result:
$"${columnName}"="Robusta"
Implementation Examples
Field Setup - Dataset name: newDS - New dataset name: newFilteredDS
Execution Parameters - Filter: $"SIRKET"="Robusta" - Filter: $"mail"="${mailAdresi}" - Filter: $"A"="Robusta"
Technical Notes
Supported operations include "=", "!=", "<", "<=", "begins with", "ends with", "contains", "does not contain", "and", "or", and parentheses "()". The column reference format $"A" is applicable when the "has header" option is set to false in the "Read Excel to Dataset" activity.