(v24) Operators

Operators

This applies to: Visual Data Discovery

Valid operators used in Symphony are described below.

Operator	Applies to	Determines whether the data in the field you select...
Begins With	strings	Begins with the string you have specified.
Between	numbers	Falls numerically between the two numbers you specified.
Contains	strings	Contains the string you have specified.
Does Not Begin With	strings	Does not begin with the string you have specified.
Does Not Contain	strings	Does not contain the string you have specified.
Does Not End With	strings	Does not end with the string you have specified.
Ends With	strings	Ends with the string you have specified.
Equal	numbers	Is equal to the number you specified.
Exclude	numbers & strings	Includes the number or string you specify. If it does, the data is excluded from the output.
Greater Than	numbers	Is greater than the number you specified.
Greater Than or Equal	numbers	Is greater than or equal to the number you specified.
Include	numbers & strings	Includes the number or string you specify. If it does, the data is included in the output.
Less Than	numbers	Is less than the number you specified.
Less Than or Equal	numbers	Is less than or equal to the number you specified.
Not Between	numbers	Does not fall numerically between the two numbers you specified.
Not Equal	numbers	Is not equal to the number you specified.