Filter

Estimated reading: 1 minute 630 views

Filter activity is used to filter within a dataset.

*Dataset name	Reference name of dataset.
*Filter	Filter expression.
*New dataset name	It is named by creating a new dataset containing filtered data.

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

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

newDS

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

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

(

)

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

newFilteredDS