FILTER
Filter Data
Within a process, it is sometimes necessary to filter the data, for example, to post only the valid rows. The transformation can either pass the result of the filter to the Target or remove the rows that match the filter and pass the remaining rows.

| Filter Type | DE - Delete Matching Rows TR - Transfer Matching Rows |
|---|---|
| Add Options | Select fields for filtering from the fields of the Source |
| Delete Options | Remove selected filter option |