The Value Conformity node is used to check whether data set values match specific values or fall within a range of values. The node produces a new field containing Boolean values for each value conformity check that is written. If a data set value matches any of the values in a value conformity check or falls within the check's range, a True value is returned. Conversely, if a data set value does not match any of the values in a value conformity check or falls outside of the check's range, a False value is returned.
Properties
Output Field Name
This is the name of the Boolean field the node will produce for the Value Conformity Check.
Field
This is the field upon which to perform the Value Conformity Check. As discussed below, fields of different data types allow for different value matching options.
Numeric Checks
Value List
Check to see if a value matches any values from a set of values. Values in the set may be added one at a time using the New Value option or as a comma separated list with the Multiple Values option.
Range
Check to see if a value falls within a range of values. From values are included in the range, To values are not.
Date, DateTime, and Time Checks
Value List
Check to see if a value matches any values from a set of values. Values in the set may be added one at a time using the New Value option.
Range
Check to see if a value falls within a range of values. From values are included in the range, To values are not.
String Checks
Value List
Note that when using the Multiple Values option for Strings, any spaces between comma separated values will be interpreted literally. For example, suppose you wanted to add the following values:
these, are, my, values
If you were to add these values to the list as shown above, with spaces, the spaces would be added to the beginning of the String that they precede, effectively adding the following values to your check (quotes shown to emphasize spaces):
‘these', ‘ are', ‘ my', ‘ values'
To check for your actual values, you would want to add them to the list without spaces, as follows:
these,are,my,values