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'. |