Value Conformity - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

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