Filter

Filter activity is used to filter within a dataset.

Note: * Fields selected with are required, others are optional.

Dataset name example

You can use the Dataset name as shown in the example.

newDS

Filter examples

You can use the Filter as shown in the examples.

$”ad”=”ilhan” and $”Numara”=5

$”ad” begins with “il” or $”Numara”=7

$”ad” contains “han”

$”SIRKET”=”Robusta”

$”${columnName}”=”Robusta”

$”mail”=”${mailAdresi}”

$”A”=”Robusta”

“Important Note: Applicable when ‘has header’ is selected as false in the ‘Read Excel to Dataset’ activity.”

Supported operations

=

!=

<

<=

begins with, ends with, contains, does not contain, and, or

(

)

New dataset name example

You can use the New dataset name as shown in the example.

newFilteredDS