2.3 WHERE Clause: Filtering Data

Using Comparison Operators in the WHERE Clause

✅ Available Operators:

Operator	Meaning	Example
=	Equal to	WHERE Status = 'Active'
!= or <>	Not equal to	WHERE Country != 'India'
<	Less than	WHERE Age < 30
>	Greater than	WHERE Purchases > 5
<=	Less than or equal to	WHERE Discount <= 20
>=	Greater than or equal to	WHERE Revenue >= 1000

Example 1: Filter All Male from the Source DE (Where Gender = 'Male')

Target DE:

From the Source DE (Where Region != 'North'/ Where Region <> 'North')

Result of Where Region != 'North' - Target DE

Ran Both Activities in the same Workflow:

Logical Operators: AND, OR, NOT




AND:

WHERE Region= 'North' AND Gender= 'Female'

Target DE with No Records with the selected Clause:

OR: Where Region = 'East' Or Gender = 'Female'

Target DE: