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
Case sensitive	A boolean option to control whether text comparisons in the filter expression are case-sensitive.	Optional
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"

Grouped Conditions

Format: string expression using parentheses to control evaluation order
Example Result: ($"Name"="Sami" or $"Surname"="Smith") and ($"Status1"="Error" or $"Status2"="Error" or $"Status3"="Error")

Implementation Examples

Field Setup - Dataset name: newDS - New dataset name: newFilteredDS

Execution Parameters - Filter: $"SIRKET"="Robusta" - Filter: $"mail"="${mailAdresi}" - Filter: $"A"="Robusta" - Filter: ($"Name"="Sami" or $"Surname"="Smith") and ($"Status1"="Error" or $"Status2"="Error" or $"Status3"="Error") - Case sensitive: false

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.

Use parentheses to explicitly group and/or conditions when mixing them in the same expression — without grouping, everything after an or may be evaluated as a single separate condition instead of the intended combination. For example, $"A"="x" or $"B"="y" and $"C"="z" should be written as ($"A"="x" or $"B"="y") and $"C"="z" when that is the intended logic.

When Case sensitive is disabled (false), text comparisons ignore letter casing, which helps match values inconsistently capitalized across source data (similar to the case-insensitive option available in Mail Search).