Filter transformation

Overview 

Filter is a transformation executed for each processed record in the source-to-destination transformation that can be used to reject records. You can use JavaScript or SQL syntax. 

Read more about the filter transformation.

When to use this transformation

It is possible to filter out certain rows of the source dataset using simple expression. 

This transformation is only available when the source is a file or API endpoint. 

The alternative to filter transformation is to use a WHERE clause in the Source query.

Create a transformation

To configure filter transformation, go to Transformation/ MAPPING/ Additional Transformations/ Filter.