Read more about Data Workbench’s End-of-life announcement.
The Compare condition and Range condition require that you specify the type of comparison to be made for the condition.
The following table describes the available types ( LEXICAL, NUMERIC, and DATETIME).
Test Type | Description | Notes |
---|---|---|
INTEGER |
First turns the input field into an integer. If this is not possible, a value of zero is used. The test returns true only if the resulting integer input value is greater than or equal to the specified minimum value and less than or equal to the specified maximum value. |
If either of the min or max fields is left blank, the system uses the appropriate min or max value available to 64-bit signed integers. If the min or max value specified in the condition does not successfully parse to an integer value, the system substitutes zero and does not stop processing the dataset. |
DATETIME |
First turns the input field into a date. If the input field cannot be turned into a valid date, the condition test returns false. If the field can be turned into a date, the test returns true only if the input date falls on or after the specified minimum date and on or before the specified maximum date. |
If the min and max dates are not valid, the dataset are not constructed. If the min or max dates are not supplied, the system substitutes appropriately either the min date (Jan 1, 1600) or the max date (sometime in the 24th century). Adobe recommends using one of the following formats for DATETIME:
The time zone defaults to GMT if not specified. |
LEXICAL |
Returns true only if the input field is lexically greater than or equal to the string specified as the minimum and less than or equal to the string specified in the maximum value. |
Lexical comparison uses the ASCII value of characters in the strings moving from left to right comparing the characters. For the first character that does not match, the one with the larger ASCII value is considered to be the greater of the two. In the event that one string is shorter than the other, but up until that point all of the characters have been the same, the longer string is considered the greater of the two. If the strings are character for character equivalent and the exact same length, they are considered lexically equivalent. |