Was this helpful?
Compare to Constant
 
Rule
CompareToConstant
Default Rule Name
<fieldname>_CompareToConstant
Description
Compares a field against a constant value. After comparing the field values to the constant value, the values that are equal to the constant value are written to the Pass Target. Values that are not equal to the constant value are written to the Fail Target.
Rule Parameters
Operator: Select from one of the following comparison operators:
Is Equal To
Is Not Equal To
Greater Than
Greater Than Or Equal To
Lesser Than
Lesser Than or Equal To
Field Value: In this text box, type the constant value to compare. For equal or not equal you can list one or more constants separated by a “|” character.
Supported Data Types
String, Date, Timestamp, Boolean, Numeric, Double, Float, Long, Integer
Remarks
The Is Equal To operator is not recommended to use on double or float field comparisons.
Do not use quotation marks with string data.
In case of date, datetime, and time field, the constant value should be in ISO 8601 format.
If source has GMT timestamp data, the constant value should end with 'Z'.
Last modified date: 10/30/2024