Type 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 Type Conformity node is used to check whether data set values conform to patterns. The node produces a new field containing Boolean values for each type conformity check that is written. If a data set value matches the pattern in a type conformity check, a True value is returned. Conversely, if a data set value does not match the pattern in a type conformity check, a False value is returned.

Properties

Output Field Name

This is the name of the Boolean field the node will produce for the Type Conformity Check.

Field to Check

This is the field upon which to perform the Type Conformity Check. As discussed below, fields of different data types allow for different pattern matching options.

Type Conformity Checks

  • Regular Expression - This option allows you to verify whether a field's value conforms to a specific Java Regular Expression Pattern. Any Java Regex Pattern can be used.
  • Number - This option allows you to verify whether a field's value conforms to a specific number formatting pattern. Either predefined formatting patterns or a custom pattern can be used.
  • Date - This option allows you to verify whether a field's value conforms to a specific date formatting pattern. Either predefined formatting patterns or a custom pattern can be used.